Ok, try this variation of it:

=IF(ISNA(VLOOKUP(A159,'1st'!$I:$I,1,0)),"not
present",IF(VLOOKUP(A159,'1st'!$I:$I,1,0)=A159,"W" ,"A"))

Hope this helps.

Pete

Balticjo wrote:

Sorry should have said this is what i'm using at the moment

=IF(VLOOKUP(A159,'1st'!$I:$I,1,FALSE)=A159,"W","A" )

"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