If you're not returning a value but just checking whether an item exists in a
list then MATCH would be better:

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

"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