lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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")
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
second table in column L
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
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>