Looking to change the Value of a row of cells Automatically in XL 2010

[Blueplaidedpulp]

Hi, I'm not sure if what I want to do is possible I've looked through the Forums and can't seem to find anything.

I would like to have a row of values change based on the value of a cell automatically. I have a Chart that has a cost list which increases depending on the level, right now i have the cost of the current level displayed seperately and have been copying pasting manually as i go up a level. I am wondering if there is a formula where you could enter just the level and it would automatically change the cost values to the correct one based on the chart.

I would be willing to do a formula that does it cell by cell rather then by row I just want it to automatically adjust the costs.

Hope this made sense, and Thanks in Advance!

 

[dave3009]

Hi and welcome

Depending on the layout of the data you might be OK to use VLOOKUP. Here I've created a table of dates and values, you lookup the date and return the value. If you had a similar set up you could use this methodology and chart the results from the VLOOKUP

Excel Workbook
	A	B	C	D
1	Date	Value 1	Value 2	Value 3
2	18/06/2012	638	580	347
3	19/06/2012	398	437	454
4	20/06/2012	391	322	594
5	21/06/2012	597	751	375
6	22/06/2012	698	575	472
7	23/06/2012	597	477	362
8
9	Date	Value 1	Value 2	Value 3
10	18/06/2012	638	580	347
Sheet3

Excel 2007

Cell Formulas
Range	Formula
B10	=VLOOKUP($A10, $A$2:$D$7, COLUMN(), 0)
C10	=VLOOKUP($A10, $A$2:$D$7, COLUMN(), 0)
D10	=VLOOKUP($A10, $A$2:$D$7, COLUMN(), 0)