Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to vlookup value and return true or false / yes or no in Excel?

To vlookup values in a list, and display True / False or Yes / No for the result. In this article, you will learn how to vlookup and return true or false / yes or no in Excel.

Vlookup and return true or false / yes or no in Excel

Combine multiple worksheets/workbooks into one worksheet / workbook:

Combine multiple worksheets or workbooks into one single worksheet or workbook may be a huge task in your daily work. But, if you have Kutools for Excel, its powerful utility – Combine can help you quickly combine multiple worksheets, workbooks into one worksheet or workbook. Download the full feature 60-day free trail of Kutools for Excel now!

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial

arrow blue right bubble Vlookup and return true or false / yes or no in Excel

Supposing you have a list of data in range A2:A11 as shown in following screenshot. To search the Column A according to the data in Column D and display the result True or false / Yes or No in Column B. For axample, if the Column A constains the same value of Column D, the vlookup formula will disaply Yes or True in Column B.

1. Select cell B2, copy and paste formula =IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)), "No", "Yes") into the Formula Bar, then press the Enter key. See screenshot:

2. Drag the Fill Handle down to the range you need to vlookup and return yes or no. For the Yes result, it means that the Vlookup value exists in the adjacent cell in column A. If it returns No, the vlookup value doesn’t exist.

Note: For returning True or False, please replace the “Yes” and “No” in the formula with “True” and “False”: =IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)), "False", "True").

Tip: If you want select entire rows based on cell value in a certian column in Excel, you can try the Select Specific Cells utility pf Kutools for Excel as below screenshot shown. You can go to free download the software with no limitation in 60 days.

Office Tab - Tabbed Browsing, Editing, and Managing of Workbooks in Excel:

Office Tab brings the tabbed interface as seen in web browsers such as Google Chrome, Internet Explorer new versions and Firefox to Microsoft Excel. It will be a time-saving tool and irreplaceble in your work. See below demo:

Click for free trial of Office Tab!

Office Tab for Excel

Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for you.

  • Designed for 1500+ work scenarios, helps you solve 80% Excel problems.
  • Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  • Being used by 110,000 elites and 300+ well-known companies.

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Auwal Abubakar Muhammad · 8 months ago
    Hello there,
    Kindly help me with function/command that will arrange same vaue in the two columns given below:
  • To post as a guest, your comment is unpublished.
    Satir · 2 years ago
    I need help using vlookup with if function for yes or no but this time the result we be as value not as Yes / NO or True or False, the oppsite of the above example.
    • To post as a guest, your comment is unpublished.
      Bailey · 2 years ago
      Satir, late message but I just did the exact job that you are tasked with.

      Original Version
      =IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)), "False", "True").

      My Version:
      =IF(A2="","",(IF(ISNA(HLOOKUP(A2,'1. Round One'!$C$2:$Q$2,1,FALSE)),"",'1. Round One'!$H$5&" "&'1. Round One'!$H$6&" "&'1. Round One'!$H$7)))

      The difference is mine will return 3 values that are related to the value I just looked up.. aswell as it wont display anything unless the value was found.. to simply it for your use, ive provided one below.

      =IF(ISNA(VLOOKUP(A2,$D$2:$D$185,1,FALSE)), "B1", "B2").
  • To post as a guest, your comment is unpublished.
    Satir · 2 years ago
    can i use Yes / NO in vlookup to return a result to number or value. all the exmple gives result of Yes / NO or True/ False i need oppsite to it.