Excel 2007. I have two spreadsheets that I am trying to cross reference. Both spreadsheets contain patient names, but only one spreadsheet contains ID numbers associated with each patient. I am trying to take those ID numbers from the first spreadsheet and search for their respective names in the second sheet, and then match the ID numbers to each name on the second spreadsheet.
Here is what I have tried so far, but I am not getting any positive results:
=IF(ISERROR(VLOOKUP($A4, Master!$A$1:$G$1000,1, FALSE)), "Master!", VLOOKUP($A4, Master!$A$1:$G$1000,1, FALSE))
but this only yields "Master!" for each cell.
Anyone have any ideas?
Here is what I have tried so far, but I am not getting any positive results:
=IF(ISERROR(VLOOKUP($A4, Master!$A$1:$G$1000,1, FALSE)), "Master!", VLOOKUP($A4, Master!$A$1:$G$1000,1, FALSE))
but this only yields "Master!" for each cell.
Anyone have any ideas?
