| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX() columns first
Note that I assumed that your values are sorted in ascending order like in
your example -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Peo Sjoblom" wrote in message ... This will return 3 =MATCH($I$3,INDEX($L$1:$P$4,,MATCH($H$3,$L$1:$P$1, 1)),1) if you want to return what's in the cell you need to build a bit more =INDEX($L$1:$P$4,MATCH($I$3,INDEX($L$1:$P$4,,MATCH ($H$3,$L$1:$P$1,1)),1),MATCH($H$3,$L$1:$P$1,1)) you can shorten it using offset however then the formula will be volatile -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "spxer" wrote in message ... __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 in H3 of 251. I have a value in I3 of 19492. The correct column to find is M. The correct row is 3. The result I wish to return is 3. Suggestions? -- spxer ------------------------------------------------------------------------ spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025 View this thread: http://www.excelforum.com/showthread...hreadid=568648 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
| Help with grouping columns | New Users to Excel | |||
| cell color index comparison | New Users to Excel | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
