How to create a lookup table with an added varable?
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?
|