I Want to find out the data present in the cell, based on data present in other cells. Below is an example.
In this excel file, I want to find out data present in column C based on data present in column B and column A. For example. If emailID is “firstname.lastname@example.org” and Company is “Rediff” then it should return me representative column’s value “Re4”. If EMailID is email@example.com and company is TCS, it should return me value “Re2” from the Representative column.