Take a look at VLOOKUP(), which will return text; another alternative
is to nest a MATCH() function inside an INDEX() function but this
option is less intuitive.

There are many posts in this forum that deal with "comparing two
spreadsheets", so you should have a wide and deep body of suggestions
to work with.