Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
table, index, array, match, lookup?
_K____L____ _M ____N ____O ____P ............. 1____100___200_ __300 __400 ___500 2____19000_19000_19000_19000_19000 3____19240_19480_19720_19960_20200 4____19600_20200_20800_21400_22000 I have a value of 299 in H3 i wish to compare to L1:P1. The correct column is M. With that established, I now want to compare a value of 19490 in I3 to the numbers in column M. I wish to return the row number. In this case, row 3. How can I accomplish this? I have tried several suggestions. None have worked. -- spxer ------------------------------------------------------------------------ spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025 View this thread: http://www.excelforum.com/showthread...hreadid=569606 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
Lookup nearest value (Index & Match) | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |