Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to get yes or no in Vlookup in Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-01-2012
Member
 
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.

Reply With Quote
  #2  
Old 24-01-2012
Member
 
Join Date: May 2011
Posts: 518
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")
Reply With Quote
  #3  
Old 24-01-2012
Member
 
Join Date: May 2011
Posts: 444
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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to get yes or no in Vlookup in Excel"
Thread Thread Starter Forum Replies Last Post
Need help to get rid of #n/a error in Excel Vlookup Culpritism MS Office Support 2 24-02-2012 06:39 PM
How to Copy formula using Vlookup on Excel? Chellappan Windows Software 2 04-01-2012 07:20 PM
Excel - Multiple vlookup mike_2011 Windows Software 1 28-07-2011 03:40 AM
vlookup pictures in excel Olivia Software Development 6 16-07-2011 11:02 AM
Vlookup problem in Excel Hebrew Windows Software 5 02-01-2010 06:28 PM


All times are GMT +5.5. The time now is 05:56 PM.