=IF(ISNA(VLOOKUP(<your parameters)),0,VLOOKUP(<Your parameters))

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Help" wrote:

I am using VLOOKUP to pull data from another spreadsheet.
I have a list of staff names on each spreadsheet - and use VLOOKUP in
worksheet 1 to find the names in worksheet 2.
But I have additional names in worksheet 1 that do not appear in worksheet 2.
If those names don't appear in worksheet 2 - I want VLOOKUP to enter a 0 in
my column of data in worksheet 1.
How do I do that?