IF function w/arrays not working

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.
 
A

Aladin Akyurek

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Average If 2
SUMIF Greater than or equal to 4
Enter data into a cell that already has a function. 2
using the address referenced in a linked cells 10
Another "working with dates ?" 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
How do I return multiple occurrences of a match in an array? 1

Top