Hi Leveleyed, welcome to the forum.

You should be able to use a VLOOKUP formula, for example:

=VLOOKUP(G2,B1:C10,2,0)

This looks for the value from G2 in B1:B10 and returns the corresponding value from C1:C10. If it doesn't find a match, you'll see an error. To hide the error you can use:

Excel 2007 or newer:
=IFERROR(VLOOKUP(G2,B1:C10,2,0),"")

Excel 2003 or earlier:
=IF(ISERROR(VLOOKUP(G2,B1:C10,2,0)),"",VLOOKUP(G2,B1:C10,2,0))