|
| ||||||||||
| Tags: microsoft excel, microsoft office, office application, spreadsheet, vlookup |
Sponsored Links
How to get yes or no in Vlookup in Excel
MS Office Support
 |
| | Thread Tools | Search this Thread |
|
| ||||||||||
| Tags: microsoft excel, microsoft office, office application, spreadsheet, vlookup |
|
| | Thread Tools | Search this Thread |
|
#1
24-01-2012
| |||
| |||
| How to get yes or no in Vlookup in Excel
 |
|
#2
24-01-2012
| |||
| |||
| 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
24-01-2012
| |||
| |||
| 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 |
|
|
| Thread Tools | Search this Thread |
| |
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 |
| Sum up a number of matches in Vlookup in Excel | Abélard | MS Office Support | 2 | 24-02-2012 05:58 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 |
