controlling the return text from Vlookup()

[lezawang]

Hi I want to compare 2 tables to see who attended the conference/meeting.
So I used vlookup() but what I want to do, instead of Vlookup returning the name, I want vlookup returning "Attended"! How can I do that. I managed to do the "Not Attend" only

D2=IFERROR(VLOOKUP(A2,L:L,1,FALSE),"not attend")

name	dept		attending
john1	it		john1
mary1	hr		mary1
david1	sales		not attend
sarah1	marketing	sarah1
alex1	sales		not attend
anna1	admin		anna1
lary1	it		not attend

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

second table in column L

attended

andy1

mary1

nameir1

janet1

anna1

sarah1

kim1

andy2

john2

nameir2

janet2

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[RoryA]

I'd suggest something like this:

=IF(ISNA(VLOOKUP(A2,L:L,1,FALSE)),"not attend","Attend")

 

[AlanY]

try

=IF(ISERROR(VLOOKUP(A2,L:L,1,FALSE)),"not attend","attended")

 

[Fluff]

How about
=IF(ISNA(VLOOKUP(A2,L:L,1,FALSE)),"not attend","attended")

 

[lezawang]

Thank you all. It works! amazing really. Thank you

 

[Fluff]

Glad we could help & thanks for the feedback