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.