Results 1 to 3 of 3

discrepancy in vlookup function results

Threaded View

  1. 10-08-2017, 02:30 AM #1
    nazaninibb
    nazaninibb is offline
    Registered User
    Join Date
    04-26-2015
    Location
    Tehran
    MS-Off Ver
    2007
    Posts
    57

    discrepancy in vlookup function results

    Dear all,
    I have encountered a problem in using vlookup function.

    I have two columns with 65536 rows. When I compare column A with column B the results are different from comparing column B with column A.

    However around row number 2400 the results are the same.

    Can you advice me how to solve this problem?

    Regards

    Nazanin
    Last edited by nazaninibb; 10-08-2017 at 02:33 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP function not displaying results
    By B24Mike in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2015, 01:09 PM
  2. How to reference one cell below the results of a VLOOKUP function
    By Sackie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-23-2013, 07:55 PM
  3. Vlookup results based on IF Function
    By numbersdntlie in forum Excel General
    Replies: 9
    Last Post: 12-21-2011, 01:24 PM
  4. IF function to check results of a VLOOKUP and adjust value accordingly
    By DarrenHeaphy in forum Excel General
    Replies: 3
    Last Post: 12-06-2010, 04:24 PM
  5. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  6. Method to find discrepancy in sumif function
    By mingali in forum Excel General
    Replies: 1
    Last Post: 09-05-2009, 02:19 PM
  7. Vlookup data discrepancy
    By EK in forum Excel General
    Replies: 4
    Last Post: 09-28-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1