This is doubtless very, very simple but I've been staring at it for hours!

I have a spreadsheet with a series of unique ID numbers in column 1 of sheet
1. I have a list of people with ID number and name in sheet 2. I want to
lookup the relevant name for each ID and copy it into column 2 on the first
sheet.

I've used:

=VLOOKUP($A4,'Report data'!$A$1:$K$500, 9,FALSE)

This has worked fine before on a different spreadsheet (I was testing out
vlookup) but now returns #N/A.

I've tried omitting the $ in the ranges, that makes no difference.

Can anyone help please?

Sue