I have two excel sheets, each has a column called unique ID. The first sheets has a value associated with that ID, the second has a description. How do I pull the description from sheet two into sheet one where they both have the ID in common ?
How it works:
Write this Formula in Cell
=IFERROR(VLOOKUP(A3,Sheet2!$A$3:$B$7,2,FALSE),"No Match ID")
Or you may use this Formula also:
- Drag both formulas down.
- Adjust cell references in the formulas as needed.