LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 143
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.


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a pivot table if the pivot table icon or menu ite. Lynn@WS Charts and Charting in Excel 1 December 16th 04 02:36 AM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM
Index table lookup anomaly Carole O Excel Worksheet Functions 9 December 9th 04 04:33 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
Lookup Table Ben Excel Worksheet Functions 7 November 30th 04 07:05 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"