Results 1 to 2 of 2

Thread: Update price list - please help!

  1. #1

    Unhappy Update price list - please help!



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

    I've been suffering in silence for a week, trying to figure this out by myself, but the more I try and research this, the more I'm getting confused. Please help!


    This is what I have:


    Sheet 1 (Master Price List with 11000 part numbers)
    Column A: Part number
    Column B: Price (New Prices)


    Sheet 2 (Stock list of 900 part numbers with OLD prices)
    Column A: Part number (in some cases containing 2 or more part numbers - OLD and NEW)
    Column B: Price (Old Prices)


    I need to pull the new prices from Sheet 1, Column B and insert into Sheet 2, Column B


    I have used the following formular to fulfill this task:
    =VLOOKUP(A2,Sheet1!A2:B10825,2,) which has been partly successful.


    The problem is that many part numbers in Sheet 2, Column A, contain 2 part numbers in a cell an OLD number and a NEW number (which is in Sheet 1, Column A).


    I can't work out how to set up the formula so that it checks partial data from Sheet 2, Column A to match the relevant part number in Sheet 1, Column A.


    For example in Sheet 2, Column A, I have 2 part numbers in one cell: "1111111 = 2222222" but of course excel can't extract 2222222 from one cell to match the relevant cell with 2222222 in Sheet 1, Column A.


    I apologise if this is long winded, I just want to make sure you understand my problem from the outset!


    Thanks in advance.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Did you try a wildcard?

    e.g.

    =VLOOKUP("*"&A2&"*",Sheet1!A2:B10825,2,)


    This will search sheet2, column A for the first cell containing substring that is in A2.


Posting Permissions

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