| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use find with Index and Match
I have this formula:
INDEX([POlog.xls]POLOG!$O$5:O2003,MATCH($H5,[POlog.xls]POLOG!$P$5:$P2003,0)), but I want to find the Match in Range(P5:X2003) not just (P5:P2003). In other words, I want to find the match for H5 in multiple columns. Is it possible, and if so, how? TIA Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDEX to find the match | Excel Discussion (Misc queries) | |||
| Using INDEX and MATCH to find data in 2 different sheets | Excel Worksheet Functions | |||
| INDEX, FIND.... MATCH???? | Excel Discussion (Misc queries) | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
