IF function w/arrays not working

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

I need to search a user inputed number from a list of data
and then return an answer from a corsponding cell to the
original cell. Make sense?

Here is what I have:
This is what I have for a formula in cell B4, it is not
working...
{=if(a200:a7566=a4&"",x200:x7566,"Not a Customer)}

a200:a7566 is the customer data sorted by 6 digit number.
x200:x7566 is the data that I want to have put in the cell
a4 is the user inputed customer number.
 
No need for a formula to be confirmed with control+shift+enter...

In C4 enter:

=MATCH(A4&"",A200:A7566,0)

In B4 enter:

=IF(ISNA(C4),"Not a Customer",INDEX(X200:X7566,C4))
 
Back
Top