+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP absolute beginner, quick help please

  1. #1
    Registered User
    Join Date
    05-06-2013
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    29

    VLOOKUP absolute beginner, quick help please

    I have a workbook comprised of 20 or so worksheets, there is a VLOOKUP formula on the worksheet (titled 'data') with sellout totals which points to the price list worksheet which has the most recent prices, at the end of every quarter we get a new price list with updated prices for some products, so in the past I have either added the updated prices to the that worksheet (e.g. PL 2014 Q4), then deleted the rows with the old prices or copied and pasted the 2014 Q4 price list in to a new worksheet which is then named PL 2015 Q1 and so on..

    In the past the VLOOKUP formula has worked fine on the worksheet titled data, but because we recently expanded our product line, we have many new SKUs which I have spent the last week adding to the new worksheet (titled 'PL 2015 Q1')
    The formula works fine on the older SKUs, (black text, first three rows) but does not work on any of the new ones (green text, bottom 4 rows) - I have added a screenshot to illustrate:

    VLOOKUP Question.JPG

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,465

    Re: VLOOKUP absolute beginner, quick help please

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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] Quick beginner question-Why doesn't On Error Exit Function work?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-09-2013, 06:23 AM
  2. Absolute beginner
    By Speckydodge in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-25-2009, 04:20 AM
  3. Quick absolute reference question
    By zincyo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2007, 06:30 PM
  4. Vlookup in VBA for a beginner
    By Jeugo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2006, 06:57 AM
  5. [SOLVED] Quick method to add absolute references in Excel using keyboard
    By photon63 in forum Excel General
    Replies: 2
    Last Post: 02-11-2005, 05:06 AM

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