Results 1 to 12 of 12

Not returning correct values in all cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-03-2009
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2010
    Posts
    132

    Not returning correct values in all cells

    Hi,
    If someone could look at this immediately please, donno if its a silly mistake
    in sheet "HMC_Facility_wise_PR_PO.." i have taken data from row L to combine with d to have a combination shown in E
    Now in sheet "raw prpo report" i want to find this data in row A and if found that match should write in sheet "HMC_Facility_wise_PR_PO.." in column F else return with "Not found" but something strange some values not matching
    one example is row 28 in sheet"HMC_Facility_wise_PR _PO.." value 1691662-01 is there in sheet "raw prpo report" but still in column f showing as not found whereas it should display value(1691662-01), could you throw light please


    Thanks
    mp
    Attached Files Attached Files
    Last edited by maximpinto; 02-19-2015 at 01:53 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMPRODUCT Not Returning Correct Values
    By thecircularwriter in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 01-10-2015, 06:42 PM
  2. [SOLVED] VLOOKUP returning all correct values except the first.
    By K.J.Dub in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2012, 01:05 PM
  3. [SOLVED] Nested If functions are not returning correct values.
    By ybortony in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 01:50 PM
  4. VLOOKUP is returning the "title" of my column in the correct cells.
    By cluelessatwork in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-29-2011, 02:53 PM
  5. Formula sometimes returning correct answer and sometimes returning 0
    By redimp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2010, 06:28 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