Excel Compare and Return Result

Hi,

 

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.

Spreadsheet A:

Name Role

Mary Secretary

Mary HOD

Jane Secretary

Jane HOD

Jane Admin

 

Spreadsheet B:

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?

 

Thanks!

By: newbie881

Leave a Reply

Your email address will not be published. Required fields are marked *