Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Match Help
I'm having a real difficult time with this andi 'm sure it's no problem for you experts. I'm trying to find a match in columns A,B,C,D,E, or F and have the function return what's in column A in each instance. But the match could be in any of the columns every time I enter a new number. Here is my formula. =INDEX($A$14:$A$50000,MATCH(B4,$B$14:$F$50000,0)) A B C D B4 Formula MS21083D9 AN364D918 AN364D918A MS20364D918 MS21083N02 F22NTM-256 F22NTM-02 MS21083N04 F22NTM-440 F22NTM-40 MS20364-440A MS20364-440 AN364-440A AN364-440 Thank You -- MrSales ------------------------------------------------------------------------ MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572 View this thread: http://www.excelforum.com/showthread...hreadid=525492 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Match or Index Question | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |