Results 1 to 3 of 3

Thread: How to get yes or no in Vlookup in Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    59

    How to get yes or no in Vlookup in Excel

    Please, what is the proper vlookup syntax to get a yes or no answer in a vlookup formula, instead of a column return. I tried some addins but that does not worked. So I need some sample which can state the following in Microsoft Excel.

  2. #2
    Join Date
    May 2011
    Posts
    526

    Re: How to get yes or no in Vlookup in Excel

    Try this: =IF(ISNA(VLOOKUP(A1,table,1,0)),"no","yes")where A1 is the cell with the lookup value, and table is a named range covering your data. OR If you're checking to see if a value is in a single column/row list:=if(isnumber(match(a1,sheet2!a:a,0)),"yes - a match","no match")

  3. #3
    Join Date
    May 2011
    Posts
    449

    Re: How to get yes or no in Vlookup in Excel

    I am not sure about what the exact formula for that is. That can be complicated. I will recommend you to go through the below link in detail to find out how you can do it. The below link contains the complete syntax and detailed information on vlookup.
    VLOOKUP

Similar Threads

  1. Need help to get rid of #n/a error in Excel Vlookup
    By Culpritism in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:39 PM
  2. How to Copy formula using Vlookup on Excel?
    By Chellappan in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 07:20 PM
  3. Excel - Multiple vlookup
    By mike_2011 in forum Windows Software
    Replies: 1
    Last Post: 28-07-2011, 03:40 AM
  4. vlookup pictures in excel
    By Olivia in forum Software Development
    Replies: 6
    Last Post: 16-07-2011, 11:02 AM
  5. Vlookup problem in Excel
    By Hebrew in forum Windows Software
    Replies: 5
    Last Post: 02-01-2010, 06:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •