+ Reply to Thread
Results 1 to 2 of 2

Help with lookup pricing

  1. #1
    Registered User
    Join Date
    09-25-2014
    Location
    Australia
    MS-Off Ver
    2010, 2013
    Posts
    39

    Help with lookup pricing

    Hello Everyone,
    I am in need of some help. i am developing a sheet to make my life easier looking up pricing from sheet to sheet. I have copied our supplier price list into my sheet on "sheet 2" and on "sheet 1" i have all my products that i require pricing for on "sheet 1" i then need a macro to look into "sheet 2" and match the first 5 digits of the product code and then put the price from the cell to the right over to "sheet 1" beside the correct product code. there will be alot more products in "sheet 2" so it only needs to update or move pricing for products i need.
    Any help would be great,
    Regards
    Anthony
    Attached Files Attached Files

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,693

    Re: Help with lookup pricing

    This doesn't need VBA.

    In Sheet 2, insert a new column on column A (push your data to the right). In cell A2, insert this formula =VALUE(LEFT(B2,5)) and copy down.

    In Sheet 1, cell B2, insert this formula =VLOOKUP(A2,Sheet2!A:C,3,0) and copy down.
    多么想要告诉你 我好喜欢你

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to compare current pricing and costs with suggested pricing
    By dearnne in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2013, 07:01 PM
  2. Pricing Guide/Chart with variable pricing increases
    By HSDesigns in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-23-2013, 04:49 PM
  3. [SOLVED] Calculate Pricing from Start and End Date with different Pricing Weight for Each month
    By xyang06 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2013, 02:54 AM
  4. [SOLVED] Pricing Lookup based on qty bought
    By playtowinpb@msn.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2012, 03:01 PM
  5. [SOLVED] Pricing Grid for t-shirt pricing
    By theprint in forum Excel General
    Replies: 5
    Last Post: 03-19-2012, 12:20 PM
  6. Multiple lookup based on date range pricing
    By posttoamit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2011, 05:52 PM
  7. Volume Pricing Lookup using Array
    By adventureli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2010, 12:51 PM
  8. Cust & Product lookup pricing between date ranges
    By Bobo Fisherman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2009, 05:01 PM

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