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 ?


enter image description here

How it works:

  • Write this Formula in Cell C3 of Sheet 1:

    =IFERROR(VLOOKUP(A3,Sheet2!$A$3:$B$7,2,FALSE),"No Match ID")
  • Or you may use this Formula also:

    =IFERROR(INDEX(Sheet2!B$3:B$7,(MATCH($A3,Sheet2!A$3:A$7,0))),"No Match")


  • Drag both formulas down.
  • Adjust cell references in the formulas as needed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.