auto fill data into a cell from a lookup table

T

Tetradpoint

Does anyone know how to set up a cell formula so that if the data in a cell
(such as a county name) is entered, an amount is placed in the cell in the
next column?
 
J

JulieD

Hi

use VLOOKUP to do this

say you have your list of countries and amounts on sheet 2 in the range
A1:B100

and then on sheet 1 you want to type a country name in cell A1 and have the
amount appear in B1
the formula for B1 would be
=VLOOKUP(A1,Sheet2!$A$2:$B$100,2,0)
which says, look at the value in A1, find it in the first column of the
table in Sheet2 and return the associated value from the second column of
this table where there is an exact match
 
Top