Hello excel Guru
I thank you in advance for any of your help
1st column (A) I' have data
2nd column (B)i have a unique list that is the "Criteria list"
3rd column (C) is the result I try to Achive
In cell C2 I need a formula that allows me to look up in Colulmn A, see the criteria in column B and than the result in Colum C including Duplicate
Origin/ unique list /Result
1 1 1
9 9 1
12 12 9
3 3 9
4 4 9
6 6 12
6 1 12
9 7 3
1 4
7 6
7 6
7 7
9 7
12 7
Thank You
Bookmarks