If I have a list of names in column A and want to search that column for a subset of those names, and for "true" results generate the text "PCG" in column B of the corresponding row, which formula do I need to enter for column B? I'd like to do this as an array formula for all of column A and include approximately 30 names to search for. Visual example, searching column A for the names "John Smith" "Adam Pierce" and "Lisa Saxon" would generate "PCG" in column B....
<tbody>
</tbody>
Phil Bauer | |
John Smith | PCG |
Jodi Arlington | |
Adam Pierce | PCG |
Lisa Saxon | PCG |
Joe Fordham |
<tbody>
</tbody>