Compare 2 sets of data in Excel and returning a value when multiple columns match

Posted by Susan C on Super User See other posts from Super User or by Susan C
Published on 2012-11-09T22:51:17Z Indexed on 2012/11/10 11:07 UTC
Read the original article Hit count: 88

I have a data set for employees that contains name and 3 attributes (job function, job grade and location). I then have a data set for open positions that contains the requisition number and 3 attributes (job function, job grade and job location). For every employee, i would like the three attributes associated with them compared to the same three attributes of the open positions and have the cooresponding requisition numbers displayed for each employee where there is a match.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about excel-2007