N
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.
=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.