+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP Product numbers and price lists

Hybrid View

Donkey Kong VLOOKUP Product numbers and... 03-11-2009, 05:00 PM
Donkey Kong Re: VLOOKUP Product numbers... 03-11-2009, 05:11 PM
  1. #1
    Registered User
    Join Date
    03-11-2009
    Location
    MOntreal
    MS-Off Ver
    Excel 2003
    Posts
    2

    VLOOKUP Product numbers and price lists

    Hi Guys!

    I am new to VLOOKUPS, I saw our finance guy use it the other day and this is what I need to save tons of time on a few projects I am currently working on. I hope someone can teach me how to do this.

    My goal is to add previous years pricing by searching by product codes. I could simply copy and paste however items get cancelled every year and new products get added so they never line up.

    So here is what I am working with:
    I have 2 Workbooks: "2009 Price.xls" and "2008 Price.xls"
    Worksheet are both called "SKU"

    I want to find product by product code with price and and price to 2009 pricing book

    Product Code is in column A and the Price is in Column B

    Can I do VLOOKUP within different workbooks?
    What formula would you suggest?
    So if the previous year I had 500 products and now I have 450, I want to line up the ones still available.

    I hope this makes sense.

    Thanks
    marc
    Last edited by Donkey Kong; 03-11-2009 at 05:14 PM.

  2. #2
    Registered User
    Join Date
    03-11-2009
    Location
    MOntreal
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: VLOOKUP Product numbers and price lists

    Here are 2 simple versions of the files
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1