I have a spreadsheet that has a ID number in column A and an airport
identifier in column B in sheet 1. I want to return a value ("1") if the ID
number and airport identifier matches the ID and airport identifier in sheet
2. The problem is that sheet 2 will have multiple matching ID numbers and
multiple airport identifiers (column B and C). For example:

Sheet 1
A B
1021 KSUN (I want to return a "1" if KSUN matches any of the rows that
match the ID of "1021")

Sheet 2

A B C
1021 KABC KSTL
1021 KCMH KMEM
1021 KVNY KSUN