Return cell reference as result of if statement with vlookups.
- by EMJ
I have two sets of data in excel. One contains a set of data which represents the initial step of a process. The other set of data represents the additional steps which take place after the first step is completed. Each of the data records in the "additional step data" has an id in a column. I need to find the identifying codes of the "additional step data" which correspond with the initial step data records.
The problem is that I have to match the data in 4 columns between the two data sets and return the id of the "additional step data".
I started by doing a combination of an if and vlookup functions, but I got stuck when I tried to figure out how to get the if statement to reference the id of the matching "additional step data".
Basically I am trying to avoid having to search by manually filtering between two sets of data and finding corresponding records.
Does anyone have any idea about how to do this?