VLOOKUP function could be what you need.
You need a lookup range of at least two columns and a cell for "what" to lookup.
Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on
value. Note the downloadable sample workbooks.
http://www.contextures.on.ca/xlFunctions02.html
Also see Debra's site for info on Data Validation selection lists for inputting
the data if need be.
http://www.contextures.on.ca/xlDataVal01.html
Gord Dibben MS Excel MVP
On Thu, 10 Jul 2008 16:50:00 -0700, Jack wrote:
while I have been a user of Excel for awhile, I have never really used to any
of it potianl. Well now is the time to start using some more features of
Excel.
What I am looking to do is place a value in one cell based on the value of
another cell. I have looked at vlookup, that is how i have my data placed, I
can understand how that works when you use the vlookup formula and puts the
data it needs into that cell.
My question is how do I use the static table of data to place one value from
a cell into a different cell.
Example.
Cell A1 has a text value, so based on that text value I would like to use a
lookup table or if there is something better that is ok also, to place a
value in cell A2 and if I change cell A1 then the value in cell A2 changes.
Thanks
Jack