Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a simple file with two worksheets in. In the first worksheet (a product list) are a number of columns, including Product Code and Product Description. In the second worksheet (dispatches in January), I have Product Code. I need to insert a new column with the associated Product Description field completed based on the relevant line from the first worksheet.

I'm sure this is very easy, but its not something I've done before.

Thank you

share|improve this question

What you're looking for is a vlookup

In the second column of sheet 2 you would use something like =vlookup(A1,sheet1!$A$1:$B$100,2,false) where A1 is your product code, sheet1!$A$1:$B:100 is the table of product codes and descriptions, 2 is the column that contains product descriptions and false is for perfect matches only.

You can then drag this down and it will look up the product codes for you and return the descriptions

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .