How to check 2 matches and date within the limited range provided

Copper Contributor

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 in the table attached. Can u please help me?

 

Note: I'm using MS Office 365, but not having xlookup functionality.

 

Thanks in advance,

 

Warm Regards,

 

Jismon Joseph 

1 Reply

@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.