Hi,
How can i get the formula to give me the following on a cell. If the province is BC, then show name "Richard", if the provinces does not show BC, but all other province, show "Allard", if provinces show only MB, AB, ON, then show "Tony". How can I get a formula to get my desired output in a spreadsheet?
Province
NS
NL
ON
NS
BC
ON
MB
MB
MB
AB
John
Bookmarks