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? |
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? |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com