Excel

VLOOKUP

=VLOOKUP([検索値], [範囲], [列番号], [検索の型])