Jun 23 2020 02:31 PM
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
Jun 23 2020 08:36 PM
@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.