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

Blueplaidedpulp

New Member
Joined
Jun 18, 2012
Messages
1
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!
 

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)
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top