Thread
:
Drop down menu and two dimensional lookup in Excel 2003
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Tarburton
Posts: n/a
Drop down menu and two dimensional lookup in Excel 2003
Sound more like a straight up index ?
If your table is in Sheet1!A1:Z13 (excluding labels), with drop down menues
linked to Sheet2!A1 for the column headers and Sheet2!A2 for the row labels,
then
=index(Sheet1!A1:Z13,A2,A1)
(on Sheet2) ought to work.
(Will work if your drop down menues are forms. If you are using code then a
more detailed description might be required.)
"THE BIG O" <THE BIG
wrote in message
...
I have created a table with 26 columns and 12 rows. I have created two
drop
down menus on another tab, one for choosing a header of the columns and
the
other for the rows. I want the user to be able to choose one option from
each drop down menu and receive an answer (the intersection of the column
and
row for the options chosen) from the table.
I looked at Index/Match, two dimensional lookup, and trying to put vlookup
and Hlookup together. The two dimensional lookup would work but I dont
want
the user to have to type in = columnheader rowheader.
Any suggestions?
Thanks
Michael
Reply With Quote