Then you could use a simple Vlookup(). See Excel help on this function for more detail.

An example:

=Vlookup(A2,'Other Sheet'!$A$2:$D$100,2,0) would return matching value for lookup value in A2 from column B of sheet called "Other Sheet", where column A contains the lookup strings.