VLOOKUP & Formatting Issue

[Barking_Mad]

Hi,

I have a VLOOKUP as follows:

=VLOOKUP(B1,Sheet1!$A$1:$D$1000,3,FALSE)

The issue I have is that this returns an #N/A result. I understand (from google) this is down to formatting. So I've changed both the cells in column B and the range in Sheet1 to General (I've also tried Numbers at 0 decimal places). Neither of which work. However, when I do a straight copy and paste with a cell value from Sheet1, into a (matching value) cell in column B, the formula works fine.

Can anyone help out and advise what I'm doing wrong?