Vlookup delivers anything that is in the column you told it to take a
value from.

=Vlookup(a5;range;4;false)

looks up the search value in A5 in the table named "range" and puts
what it finds in column 4 of the line where it found the search value
into the cell of your formula.

Hans