Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using a drop down list. depending on the numbers I select I want
those to reference a number in that row and a number in that column and return the number in that intersection. I am using a separate tab for my worksheet and another tab with my chart. For example, if I select 3.0 in one cell and .94 in another cell, on my worksheet, those numbers relate to row and column value on a separate tab containing a chart. I want the return value to be where those values intersect in my chart. More details about the data layout and about the expected results would allow a helpful response. Maybe you could post a small example. Terms like "relate to" are kind of vague. Better would be terms like "equal to" or "between two values" or whatever is intended. Does the "chart" worksheet have numbers in row 1 for "relating to" the 3.0 and numbers in column A "relating to" the .94? Are those numbers monotonically increasing? Decreasing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
Lookup Table | Excel Worksheet Functions |