Hi all - hoping someone can help solve a riddle that is driving me crazy...
I have unique "names" listed in A2:P2.
If the "name" appears in A2, then Q2 = K
If the "name" appears in B2:D2, then Q2 = D
If the "name" appears in E2:F2, then Q2 = B
If the "name" appears in G2:I2, then Q2 = M
If the "name" appears in J2:M2, then Q2 = F
If the "name" appears in N2:P2, then Q2 = -
For example, "Adam" appears in H2, so Q2 should read "M".
Thanks!
Cross posted: http://www.mrexcel.com/forum/excel-q...nge-cells.html
Bookmarks