VLOOKUP Irk

N

Neil Pearce

All,

=VLOOKUP(K1106&L1106,'Summary Page'!$A$20:$E$77,COLUMNS('Summary
Page'!A:D),FALSE)

The VLOOKUP formula above works great for the majority of my look up values.
However certain cells return the result n/a even though those cells contain
the same data as the cells above.

I have used the copy and paste format only and this does not solve the
problem. I have retyped the desired text but to still no avail.

The only hint to the cause of the problem is the fact that those cells' text
that return n/a are a smidgen out of line with the rest. Something I have
previously come across when a text cell has been formatted as accountancy.

Any ideas how to fix?

Cheers m'dears.
 
E

Eduardo

Hi,
Check if there is not blank spaces in front of the names, I guess you have
them, you can get off them entering in a helper column

=trim(A1)

I suppose that your information start in A1, then copy formula down, then
copy this column on top the other as value

if this helps please click yes 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

Top