Results 1 to 16 of 16

INDIRECT(MATCH...) Formula pulling into correct place but not correct value

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2009
    Location
    Gloucestershire, England
    MS-Off Ver
    Excel 2010
    Posts
    45

    Unhappy INDIRECT(MATCH...) Formula pulling into correct place but not correct value

    The formula on the data tab of the attached spreadsheet pulls the information from the Qty, vatable, and price columns on the items tab. I need the data to move from 1 row per item on items tab to 1 row per sale reference number on the data tab. The formula works so far, it is pulling into the correct column and row but it is not pulling in the correct value. Can anyone please tell me where I have gone wrong.

    I apologise - original attachment had a corrupted formula in it. new revised one attached
    Attached Files Attached Files
    Last edited by carrach; 11-24-2014 at 07:13 AM. Reason: formula corrupted in attachment

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. Indirect function formula not correct
    By trobie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2013, 08:30 AM
  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

Tags for this Thread

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