Results 1 to 6 of 6

Vlookup or Index with match to add pricing

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    59

    Vlookup or Index with match to add pricing

    I have a sheet with over 2500 skus that need to be updated. I have the updated sheet already with pricing.
    What I want is for it to search New pricing for Sku and put the default price to the correct price
    I tried vlookup but couldn’t get it to search an array for the sku… just worked by row number
    Index might be what I need but I cant get that to work… limited ability in excel folks.. Thank you


    See attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index and Match Pricing Dilemma
    By dbsbender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-31-2019, 11:15 PM
  2. [SOLVED] Calculating invoice price from pricing matrix using INDEX/MATCH
    By UKPatriot1980 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-21-2017, 10:18 AM
  3. VLOOKUP or INDEX/MATCH with multiple column index numbers
    By cerebral87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2017, 07:13 PM
  4. Index/match pricing formula
    By Nathan 135 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-12-2016, 12:48 PM
  5. [SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  6. [SOLVED] Index/Match Multiple Criteria: Item # & Volume Level Pricing Relative to Specific Volume
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2014, 09:28 AM
  7. Moving Data with Index & Match for Pricing Sheet
    By Cameron12 in forum Excel General
    Replies: 9
    Last Post: 07-25-2012, 07:23 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