Results 1 to 2 of 2

Thread: help with vlookup formula!

  1. #1

    help with vlookup formula!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,
    I have a problem I’m trying to fix in Excel 2010.
    Basically I need to look up a value from one spreadsheet page to see if it exists, and then copy the information from and adjacent cell on the same row.
    So, sheet “Source” has two columns, listing a product code (Col A) and product details (Col B).
    In the “Display” sheet we have a list of product codes (Col C), and a space to display the detail (Col D).
    I therefore need to:
    · take a product code from Display (in Col C),
    · look it up its matching row on Source,
    · pick up the detail on Col B, and
    · display it in Col D.
    Hope this makes sense.
    Can anyone help?

  2. #2
    You can use vlookup. In D2:

    =vlookup(c2,Source!A:B,2,FALSE)

    And drag down.

    Best of luck,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •