Google Sheets: Find exact matches of values from one column in a different sheet/tab

This video is about exact match() Google Sheets different tab
Google Sheets =match() formula looks for exact or close matches to values from one list/column in another. You can even use it to look for matches in another sheet.

[imogenjohnson]

Thank you, how do you return something other than the row number in that cell?
For example if there is a match between my sheets I want it to return a 'Y' for Yes