vlookup #na's even though there are matches

J

Janis

I'm in the current sheet, doing this formula on column AI. I want to lookup
values in column AH and find a match on the 98th percentile report column K
which is the 11th column?
=VLOOKUP(AH2,'[07-0714 Bay-Downstream Ports 98th Percentile.xls]Port
History'!$A:$K,11,FALSE)
Why doesn't it find any matches? Please help. I was extremely careful. I
even cleaned both columns in case there were any spaces. The cells have
groups of letters with a comma, ie. abcd, . There are many matches. It
should find matches on the other column with another set abcd,

I can't figure out why I get all #na's.

thanks,
 

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

vlookup has all #na's even though there is a match 2
vlookup finds first match 2
vlookup 1
lookup only finds #n/a's 4
vlookup [rewrite] 0
Test cells for values if date matches 1
Vlookup, sumproduct, if, sumif... erggg! 1
How best to...? 7

Top