I have a formula using a lookup array that works if I reference the actual data I am looking for e.g. "12345678" but not if i reference a cell C12 that contains that data. Obviously I need it to look at a cell then go and check the array for a match and cannot enter the data manually.
Any help please?
We'll need to see the formula you're currently using.
Some examples would be helpful, too.
=INDEX('MTD Sales'!$M$2:$M$3000,MATCH("10427748",'MTD Sales'!$D$2:$D$3000,0))
If I replace "10427748" with the cell that contacins the data I want to search (C17) the result is #N/A
I'm guessing that the contents of C17 are text, but the contents of D2:D3000 are numeric. (or the other way)
Consequently, no match is found.
test this by trying these formulas:
One of them will probably return a valid answer.
Please Login or Register to view this content.
Does that help?
Fantastic, thank you very much. I thought I had made sure the cells were formatted the same too?
Glad you got something you can use!
If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks