I am trying to create a dynamic dropdown based on two matches. If A=F and B=G then validate C with H.
I tried to use the following, but am getting an error:
=OFFSET(F2,MATCH(A3:B3,F3:G15,0),1,COUNTIF(F3:G15,A3:B3),1)
Thanks gurus!
I am trying to create a dynamic dropdown based on two matches. If A=F and B=G then validate C with H.
I tried to use the following, but am getting an error:
=OFFSET(F2,MATCH(A3:B3,F3:G15,0),1,COUNTIF(F3:G15,A3:B3),1)
Thanks gurus!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks