Need something similar to MATCH or VLOOKUP

  • Thread starter Thread starter Brian Q. Lehmann
  • Start date Start date
B

Brian Q. Lehmann

I have two columns of text, and it's a list of short
report titles. Column A has the complete list of reports,
and Column B has a list of reports that are a subset of
Column A. There are about 3,000 reports in Column A and
several hundred in Column B. I'd like to use a function
like MATCH or VLOOKUP that can return something other
than "#N/A" whenever it can't find the value in Column A,
like maybe zero or FALSE.

Basically, I want to create a third column based on Column
A that has a value of one if that report is found in
Column B, and a value of zero if it cannot be found. Is
that possible?

Thanks,
Brian
 
Try something such as this, copied down column C as far as you have entries
in column B:
=IF(ISNUMBER(MATCH(B1,A1:A3000,0)),1,0)
 
Back
Top