LinkBack URL
About LinkBacks
her.rockstar 
Hi,
I have a cell that I would like to display a value from another table. This will depend on the month I select from a drop down list.
I was trying to use the lookup function, it just doesn't seem to want to work.
dummy6.xls
Hi,
I have a cell that I would like to display a value from another table. This will depend on the month I select from a drop down list.
I was trying to use the lookup function, it just doesn't seem to want to work.
dummy6.xls
here is a formula that should work for you: place it in cell A4
When you copy this formula to cells below A4, the ROW(A2) section will be changed to reflect the new formula position. For cell A5 it will be ROW(A3) returning the value of 3 for the look up function. And so on.
=HLOOKUP($C$1,$F$1:$Q$12,ROW(A2),FALSE)
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks