Q:
Excel 2007 - formula or macro to show value from one cell next to a given reference
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
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
ASKED:
Nov 17 2008 3:26 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
********
Have you explored VLOOKUP capabilities? You may have to shift the columns to start the lookup number followed by the value. In other words A3 will have 1.01 and B3 will be 500.
So set up the table with all lookup values in col. A and then corresponding number in col. B.
On Sheet 2, on cell A5 use =VLOOKUP(lookup number,Sheet1!A3:B50,2,FALSE). If you want to get a perfect match. Or use =VLOOKUP(lookup number, Sheet1!A3:B50,TRUE) - will get the number equal to less than matching number.
