+ Reply to Thread
Results 1 to 3 of 3

How do you compare results of vlookups not the formula themselves

  1. #1
    Registered User
    Join Date
    05-29-2020
    Location
    Indiana, USA
    MS-Off Ver
    M365
    Posts
    27

    Post How do you compare results of vlookups not the formula themselves

    I am having issues comparing the results of two vlookups. I'm looking up information based on a position from two different systems where we use the same name convention.

    Sheet1 has a phone number in 2 blocks, area code and then phone number.

    Sheet2 is from our cell phone provider

    I am trying to compare the results of 2 separate vlookups.

    Vlookup1 Cell B2
    "=CONCATENATE(VLOOKUP(A2,Sheet1!A2:C3,2,FALSE),VLOOKUP(A2,Sheet1!A2:C3,3,FALSE))"

    Vlookup2 Cell C2
    "=VLOOKUP(A2,Sheet2!A2:B3,2,FALSE)"

    The lookups report the phone numbers back correctly but I can't see to compare the results. To test this I'm using a simple IF, but ultimately will be conditionally formatting and nesting into other formulas.
    =IF(B2=C2,TRUE,FALSE)
    Attached Files Attached Files
    Last edited by Kirkules; 05-29-2020 at 01:43 PM. Reason: Solved

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: How do you compare results of vlookups not the formula themselves

    The issue is that you are comparing numeric value against text.
    Column B is text value and will not equal numeric values in Column C.

    You can use following:
    =IF(B2=TEXT(C2,"@"),TRUE,FALSE)

    EDIT: If using in CF, all you'd need is =B2=TEXT(C2,"@")
    Last edited by CK76; 05-29-2020 at 01:36 PM.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    05-29-2020
    Location
    Indiana, USA
    MS-Off Ver
    M365
    Posts
    27

    Re: How do you compare results of vlookups not the formula themselves

    Thank you, this worked. I had tried =TEXT(C2,). I'm reading up on text command now!

+ 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. Need a macro to run vlookups on pivot table results
    By juliettelam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-14-2014, 04:27 PM
  2. Need a macro to run vlookups on pivot table results
    By juliettelam in forum Excel General
    Replies: 1
    Last Post: 07-14-2014, 04:27 PM
  3. Need a macro to run vlookups on pivot table results
    By juliettelam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-14-2014, 03:48 PM
  4. Need a macro to run vlookups on pivot table results
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2014, 03:41 PM
  5. [SOLVED] Multiple Vlookups & Join results in one cell
    By dpk1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2013, 05:05 AM
  6. need formula that compare codes and gives results
    By stufito in forum Excel General
    Replies: 1
    Last Post: 01-06-2011, 09:23 AM
  7. Multiple Table Vlookups & results
    By stu_C in forum Excel General
    Replies: 7
    Last Post: 11-22-2008, 07:54 PM

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