The usual way of doing this is along the lines of:

=IF(ISNA(your_lookup_formula),"",your_lookup_formu la)

i.e. if there is an error in the lookup then return an empty string
(blank), otherwise do the lookup. You could change the "" to some error
message like "absent".

Hope this helps.

Pete

Balticjo wrote:

I'm trying to get a Vlookup to look at certain parts of a Wooksheet and tell
me if a person is in it or not and return a specific value if they are or
arent. I can get it to return the value for if they are, but if they arent
it comes back with #N/A

Can anyone please help this is doing my head in!!!

Cheers