+ Reply to Thread
Results 1 to 2 of 2

Formula keeps bringing back an offset

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Formula keeps bringing back an offset

    Here is my formula:

    =IFERROR(INDEX(Stored!$D$22:$AN$795, MATCH(D11,Stored!$E$22:$E$795,0), MATCH(E10,Stored!$C$22:$AN$22,0)),0)

    For some reason it keeps pulling back the value that is one cell to the right, so one column off.

    What could it be.

    In this example it should pull back N363 and it is pulling back O363.

  2. #2
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Formula keeps bringing back an offset

    nevermind, my error

+ 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] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  2. Asking formula in IF and bringing back same formula as one of results
    By skankingpigeon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2012, 04:30 PM
  3. [SOLVED] INDEX MATCH formula bringing back incorrect data
    By Malinky in forum Excel General
    Replies: 2
    Last Post: 06-27-2012, 08:27 AM
  4. Excel 2007 : Lookup - bringing back more than one value
    By csalcido in forum Excel General
    Replies: 2
    Last Post: 04-23-2012, 01:59 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