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.
|