Using a Vlookup within an IF formula
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
|