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