Logic Functions: One works One won't

  • Thread starter Thread starter ksnapp
  • Start date Start date
K

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
 
Back
Top