+ Reply to Thread
Results 1 to 2 of 2

Vlookup? If specific value exists return message

  1. #1
    Spammer
    Join Date
    11-21-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    387

    Vlookup? If specific value exists return message

    I want to create a message that would appear in cell a2, if and only if the text "N/A" appears in the range X22:AB40. If "N/A" does not appear then A2 is to be blank.

    I have been playing with Vlookup to do this, but cannot get it to do exactly what I want... any thoughts?

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Vlookup? If specific value exists return message

    =if(countif(x22:ab40,"n/a"),"it was matched","")
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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] Vlookup to return specific value if cell value of vlookup is specific
    By shaz0503 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-24-2015, 10:36 PM
  2. Create error message when VLOOKUP formula returns specific value
    By prodacct in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-11-2015, 01:48 AM
  3. [SOLVED] Combination IF/VLOOKUP to Return Specific Value
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-09-2013, 04:14 PM
  4. Return message if parameter not exists
    By krish T in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2010, 11:01 AM
  5. Find Specific Trailing Letters and Return Message
    By Cleman04 in forum Excel General
    Replies: 1
    Last Post: 03-20-2009, 12:06 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