auto fill data into a cell from a lookup table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Auto Fill Cell Based on Data in a different cell 4
Excel VBA 1
summarizing data from various workbooks 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Auto Fill Cell 1
Auto Fill Cells 5

Back
Top