VLOOKUP / IF Statement

[elfa]

Hello,

I have the following to solve and have been unable to get the right formula to make it work. Hope you can help.

Cell A1 has a code say it is 4-1120

Column D had a list of codes from line 1 to 100 and one of them is 4-1120. Say this is on line 50

Column E next to all of the codes has numberical values. Say the value next to 4-1120 is 500 on line 50

How do I write a formula that says if the value in A1 matches one of the values in Column D then return the value from column E in cell A2

Thanks very much
Elfa

 

[AzizKamal]

This can be achieved by writing the following formula in cell A2:

=VLOOKUP(A1,D:E,2,FALSE)