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

#### Blueplaidedpulp

##### New Member
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.

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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
ABCD
1DateValue 1Value 2Value 3
218/06/2012638580347
319/06/2012398437454
420/06/2012391322594
521/06/2012597751375
622/06/2012698575472
723/06/2012597477362
8
9DateValue 1Value 2Value 3
1018/06/2012638580347
Sheet3
Excel 2007
Cell Formulas
RangeFormula
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)

Replies
4
Views
223
Replies
3
Views
156
Replies
13
Views
124
Replies
8
Views
191
Replies
1
Views
92

1,211,737
Messages
6,103,626
Members
447,873
Latest member
dolphin_tlp

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back