Hi all,

Having some trouble with a simple VLOOKUP and I've no idea why. I've done this a million times and never had this before.

This is the formula...

=VLOOKUP(A3,[PalActive]PalActive!$A$2:$H$206,3,FALSE)

A2 is a School Name and Column 3 is a 3-5 digit ID number.

I've checked the formatting and they are both the same. Have tried the, as a numerical cells, general & text but still getting the same #N/A value.

After a manual check I know that the value 599 SHOULD be returned.


Any help greatly appreciated.

Thanks.