I have two sheet in a Google Sheet file - "Respondent vehicle list" and "Qualified vehicle list".
Respondent vehicle list contains a single column of vehicle names, one cell per vehicle.
- Toyota avalon 2013
- Ford Fusion 2015
- 2016 Jeep Patriot
- Mitsubishi
- Hollander sport 2014
- Buick regal
- Ford Edge
Qualified vehicle list contains a single column of vehicle names, one cell per vehicle.
- Ford Edge
- Hyundai Santa Fe
- Hyundai Santa Fe Sport
- Jeep Grand Cherokee
- Kia Sorento, Mazda CX-7
- Mitsubishi Outlander
Is there a formula in which I can scan through the Respondent vehicle list to see if any cell matches with the Qualified vehicle list? If it matches, ideally it'll mark the cell green or return "1" in the column next to it.
importrange + vlookup
?