Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value from a Range (depends on input to determind month)
I have a workbook set up with hundreds of single row range names with the
columns showing January to December. Each row is a different Chemical. What I need to do is have the chemicals listed on a different sheet with columns showing various data. The formula needs to pull in the month being questioned, then populate the relevant columns with the corresponding data from the range name. ie Salt may have range names for the following data by month. Budget Price, Budget Volume, Actual Price, Actual Volume, Price Variance, Volume Variance, (these are by row and months by columns). On a different sheet I want salt on a row with 1 months data for categories above to be displayed by column. If possible 1 variable cell to change the month. The rest of the workbook finds values by month because the sheets are identical in their column discipline, but this is not the case on the front summary. Hope this is clear! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value matching vertical and horizontal input | Excel Worksheet Functions | |||
List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
Return a value from a table using Column and row names as input? | Excel Discussion (Misc queries) | |||
Find and input value based on month | Excel Discussion (Misc queries) | |||
Date the input, then tell if over 7th off month | Excel Worksheet Functions |