VLOOKUP Irk
 

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.

VLOOKUP Irk
 

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

"Neil Pearce" wrote:

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.