VLOOKUP Irk

[Neil Pearce]

All,

=VLOOKUP(K1106&L1106,'Summary Page'!$A$20:$E$77,COLUMNS('Summary
Page'!A),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.

 

[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