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!
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,816
Messages
5,598,264
Members
414,221
Latest member
MD1222

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
Top