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.