Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
auto fill data into a cell from a lookup table
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? |
#2
|
|||
|
|||
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 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Tetradpoint" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing data from table | Excel Discussion (Misc queries) | |||
auto fill sequancial data | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |