I am attempting to match a value from a column in worksheet “A” with and
insert the name associated with the value in the next column over. The
value/name combinations are in worksheet “B”.

This is the formula I have that works only for the first value.

{=(IF(I5=('B'!$A$2:$A$100),('B'!$B$2:$B$100)))}

This is an example of the data in the column

Column I
118107MB
122221MB

This is an example of the data in worksheet “B”

Column A Column B
118107MB AAA
122221MB BBB


--
WilliamVierra
------------------------------------------------------------------------
WilliamVierra's Profile: http://www.excelforum.com/member.php...o&userid=26107
View this thread: http://www.excelforum.com/showthread...hreadid=394381