Excel: VLOOKUP that returns true or false?

excel excel-formula excel-2003
Svish picture Svish · May 19, 2010 · Viewed 108.7k times · Source

In Excel we have the VLOOKUP function that looks for a value in a column in a table and then returns a value from a given column in that table if it finds something. If it doesn't, it produces an error.

Is there a function that just returns true or false depending on if the value was found in a column or not?

Answer

Mark Baker picture Mark Baker · May 19, 2010

You could wrap your VLOOKUP() in an IFERROR()

Edit: before Excel 2007, use =IF(ISERROR()...)

Related questions

Microsoft Excel Macro to run Java program

I have learnt to read and write an Excel file using a Java program with the help of Jxl and POI API. Is it possible to run a Java program with the help of macros?

Read More
ROW() function behaves differently inside SUM() and SUMPRODUCT()

Problem definition: Enter any number in cell A1. Now try the following formulae anywhere on first row. =SUM(INDIRECT("A"&ROW())) and =SUMPRODUCT(INDIRECT("A"&ROW())) The first formula evaluates, the second one gives a #VALUE error. This …

Read More
Shortcut to Apply a Formula to an Entire Column in Excel

If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows! Is …

Read More