Forum Discussion
Solved
Match a drop down list while looking up...
Hi, I'm trying to do a look up from a drop down list (sheet 1): The yellow part is the place where I'm struggling to put in a formula. The light blue is the drop down list that I'd like t...
Jon.
use COUNTIFS().
=COUNTIFS(Sheet2!$A$2:$A$29,A2,Sheet2!$C$2:$C$29,C2)>0
Jon.
use COUNTIFS().
=COUNTIFS(Sheet2!$A$2:$A$29,A2,Sheet2!$C$2:$C$29,C2)>0
Was thinking there must be a single function that could do that :)
Many thanks!
Many thanks!