View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 208
Default 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.