Hi guys,
I've tried several variations of this and I keep getting an #N/A error. See attachment to follow along. Essentially though, I want cells U8:U10 to lookup cell U7 (found in row C2:Q2), look up cell T7 (found in column B4:B33), and look up cell T8:T10 (found in C3:Q3) and return the values (yes/no) in cells C4:Q33.
Sorry if that's confusing. I've highlighted the cells yellow where I want the results. Thanks!
Bookmarks