Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've tried nested lookups and just get NA# : I'm sure its's not that
complicated though. There is a table with three columns like the below: a 1 1.1 b 2 1.2 b 3 1.3 c 4 1.4 d 5 1.5 e 6 1.6 f 7 1.7 In a seperate sheet I have one cell with b in it and another with 3 in it : how can I create a formula in another cell, that uses these two cells, to return 1.3 from the table ? Any help greatly appreciated Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |