Vlookup and Hlookup

Yes - VLOOKUP works on a vertical range and HLOOKUP works on a horizontal one.

=VLOOKUP(A1,$B$2:$C$5,3,0)

=HLOOKUP(A1,$B$2:$E$3,3,0)