Match a value from a column in worksheet

[WilliamVierra]

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

 

[Aladin Akyurek]

=VLOOKUP(I5,'B'!$A$2:$B$100,2,0)

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

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

 

[WilliamVierra]

Thanks Aladin,

=VLOOKUP(I5,'Account Name'!$A$2:$B$100,2,0)

Worked! I had tried VLOOKUP earlier and it failed due to my error i
the formula.

Thanks for taking the time to reply