VLookUp not working

[Inga]

I'm trying to use VLookup to populate column H Assignment in on
spreadsheet Active All, with a value lookup in column D Project Nam
from another spreadsheet -- Investment Hours.

The formula works for the first 4 or 5 entries then goes to #NA for th
rest of the column. There are 220 rows in Investment hour
spreadsheet. Around 600 rows in Active All. So I do expect some row
to get #NA, but not to stop working after 4 or 5 rows.

The match or unique identifier is a 5 digit number for each entry (row
on both spreadsheets starting in cell A2. I've tried formatting th
numbers as general, as numbers, as text. They are sorted in ascendin
order on both spreadsheets Investment Hours and Active All.

=VLOOKUP(A2,'INV hours'!A2:Q220,4,FALSE)

The return value should be the Project Name from Investment hours an
populate in the Assignment column on Active All spreadsheet

 

[Norman Harker]

Hi Inga!

Try:
=VLOOKUP(A2,'INV hours'!$A$2:$Q$220,4,FALSE)
Then copy down.

Better still, give your VLOOKUP table a name.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.