Hope someone can help.
I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it.
EG - Sheet 1 has a cell with £500 in cell 3A
The reference 1.01 is located in cell 3B
On Sheet 2 i need to show the value of 3A in a cell, say 5A, by inputing an instruction that will look at the whole of column B on sheet 1, find the reference 1.01 and then apply the value of 3A into cell 5A on that sheet - ie sheet 2
I am working on figures imported into excel and then I am apply a reference manually.