Forum Discussion
How to check 2 matches and date within the limited range provided
Hi Team, I need the Rep name by checking the "Product", "Customer" & Rep supporting "End Date". If the rep is supporting during the data date, he/she need to be picked. I gave an example as well ...
Jismon_Joseph Try this one in J3
=INDEX(A3:A8,MATCH(1,(B3:B8=G3)*(C3:C8=H3)*(D3:D8=I3),0),1)In the attached file I visualised the individual steps (blue shaded) that were used to come to this formula.