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: 281
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