Hi,
I know VLOOK UP with 2 criteria's doesn't work so I tried Index and stuff but I'm still blocked.
So, in attachement you will see I have 3 sheets
- 1 sheet called Indi 1
- 1 sheet called Indi 2
- 1 sheet called Union
I have in Indi 1 a list of name en numbers, same in Indi 2, in the sheet Union I have a listing of persons and 2 colons named Indi 1, Indi 2.
What a want is that in colon c (Indi 1) in sheet Union that he searchs for the exact name+number in sheet Indi1 and as a result sets 0 if not in sheet Ind 1 and a 0, so for example I want H-1, I want to have 0 in colone Indi 1 and for H-2, I want to have a 1 cause he is in sheet Indi 1. (See sample in red)
Can somebody helps me? I tried everything and it makes me nuts. I have an Excel2016.
Thank you so much for your help!
Bookmarks