Logic Functions: One works One won't

[ksnapp]

Hi

Here is the function that works just fine:

{=IF(A2=Sheet1!A$3:A$104,Sheet1!B$3:B$104)}

Here is the function that refuses to work:

{=IF(A9=Sheet1!A$3:A$104,Sheet1!B$3:B$104)}

In column A of the sheet these functions are on there are ID numbers
digits at the most. In Column A of sheet 1 there are ID numbers a
(the same ones in the same order). In column B of sheet 1 there ar
names, which are of course text. I can use this type of nesting/arra
funciton to get numbers back with no problem, but this time I nee
text.

Thank

 

[Frank Kabel]

Hi
you may try the following:
=VLOOKUP(A9,Sheet1!A$3:B$104,2,0)

 

[ksnapp]

U r the absolute best thank you thank yo