Formula to cross reference data and compile into one sheet
I am needing to take data from one sheet and create a simplified version of it in another sheet. I have tried using MATCH & INDEX and VLookup formulas but none have seemed to work. Details on what I am specifically trying to do are below.
Sheet number 1 has raw data in it extracted from a survey, this raw data is connected to a specific user ID wihtin the same row. Sheet number 2 will take this raw data and reference certain cells all while using the specific user ID.
For example: sheet number one says customer003 has passed the evaluation. Sheet number 2 shows a row for customer003 and under column "evaluation" it reference sheet 1 to show the evaluation has been completed.
I was utilizing MATCH and INDEX since VLookup only references the first column but MATCH and INDEX do not seem to be working when I attempt to do this.
Does anyone know why? Thanks!