help with looking up fields

R

richsmart

Hi there,

Looking for some help with the following:

Column D contains a numeric entry - e.g. 11.0

Column AA contains list of numbers & a figure relating to that i
column AB

EG for 11.0 in column AA, there would be 14.0 in Column AB.

So if Column D = 11.0 , I want column E to automatically display th
column AB entry (in this case 14.0)

Can anyone point me in the right direction?

Many thanks!

Richar
 
A

Ardus Petus

Use VLOOKUP:

Say you have 11.0 in D1
In E1, enter:
=VLOOKUP(D1,AA:AB,2,0)

HTH
 
Top