dynamic range vlookup

  1. M

    Graphing dynanic range only up to maximum value

    I have a chart that changes dynamically with data that is entered on another sheet. I then make a scatter plot from this chart. The data goes from 0 to a maximum value (which is what is always changing) then returns back to zero. I want the graph to ignore the returning or down slope of the...
  2. C

    Need help automatically updating and workbook to just allow use to drop the new months numbers in.

    I have linked a file that is a balance sheet, Income statement, cash flow, equity, and all historical data (BS and IS). I currently add a new row into historical for the new month then update all the formulas on sheets 1-7 manually. I need a way to automatically update all the formulas for the...
    • Clearyok
    • Thread
    • automatic update dynamic range vlookup financial reports macro - help
    • Replies: 6
    • Forum: Excel Questions
  3. W

    Dynamic VLOOKUP

    It's budget time and I need to be able to do a VLOOKUP into several hundred workbooks and populate a summary page based on criteria from a dropdown list. My basic VLOOKUP is in the form of: =VLOOKUP(C3,'[ALDERSON EAST FIELD - Budget Year - 2013.xlsm]Summary Page'!$J$13:$O$29,3,FALSE) The only...

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