I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in another column.
E.g. Compare the name and if the role exist for the name, return yes. If not, return no.
Name Secretary Admin
Mary <Return Yes> <Return No>
Jane <Return Yes> <Return Yes>
How do I achieve the <Return Yes/No> part in Spreadsheet B?