+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP is not Pulling from the Correct Sheet

  1. #1
    Registered User
    Join Date
    09-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    VLOOKUP is not Pulling from the Correct Sheet

    I have a large spreadsheet with multiple sheets. On Sheet 3 I have a list of 3 types of values in column A, B and C. On sheet 1, when a number from column A on Sheet 3 is entered it will pull the information from Columns B and C on sheet 3 and insert it into the appropriate cells. For some reason, today the VLOOKUP is trying to pull from Sheet 2 C284 (which it has never been set to do and there is nothing even there).

    Sheet 1 = "Open Orders" (this is a table)
    Sheet 2 = "Closed Orders"
    Sheet 3 = Materials (contains GCASLookups)

    Original that works:
    =VLOOKUP(C195,GCASlookups,2,FALSE)

    Random one that showed up today:
    =VLOOKUP('Closed Orders'!C284,GCASlookups,2,FALSE)

    I have gone through the whole thing and this new formula only shows up in when I insert a row (how we add a new entry). It was working fine before now and I'm not sure what changed.

    I can get it to revert back just by dragging down the value from above with the correct formula, but every time I use my macro that adds a new line, it brings up the wrong formula. I have been through my macro and it shouldn't affect formatting in any way. And everything on this sheet has worked perfectly till now.


    How do I get this to change back and to stay the original way when we insert a new row into the table on Sheet 1?

    Thanks for any help in advance!

  2. #2
    Registered User
    Join Date
    09-22-2009
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2010 (Work) O365Home (Home)
    Posts
    94

    Re: VLOOKUP is not Pulling from the Correct Sheet

    attach the workbook

  3. #3
    Registered User
    Join Date
    09-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: VLOOKUP is not Pulling from the Correct Sheet

    I can't attach the original. It is confidential.

  4. #4
    Registered User
    Join Date
    09-22-2009
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2010 (Work) O365Home (Home)
    Posts
    94

    Re: VLOOKUP is not Pulling from the Correct Sheet

    populate it with dummy data?

+ 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. Replies: 3
    Last Post: 07-01-2013, 07:50 PM
  2. [SOLVED] Formula not pulling the correct data based on a drop down list
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2013, 10:46 AM
  3. INDEX ROW Not Pulling Correct Data
    By autoworke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2013, 03:16 PM
  4. Index Match not pulling in correct info
    By jeremiahbret in forum Excel General
    Replies: 1
    Last Post: 02-07-2012, 03:48 PM
  5. LOOKUP formula not pulling correct data
    By anelson02 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2009, 06:37 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