Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table_array and drop down boxes
I am working on a vlookuo formula and having trouble. I am trying to link the
table_array portion of the vlookup to the selection made in a drop down box. Think of it this way...I have 50 tables set up, one for each state, if a person selects the state of Ohio from the list the table array will now have the name of Ohio seach only in that table. =vlookup(sales tax,result from drop down box, 2) if I type in =vlookup(sales tax, Ohio,2) I get the results I need. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table_array and drop down boxes
Hi,
In a blank worksheet, design two tables like this: In A1:B3 OHIO TaxRate Sales Tax 2.5% Customs Duty 1.5% In D1:E4 TEXAS TaxRate Sales Tax 2.4% Customs Duty 5% Income Tax 6.5% Open Name box from Insert/Name/Define. In the Names in Workbook box type OHIO. In the refers to box select range for the OHIO table (A1:B100 to keep some room for future). Click Add Create a name for Texas in a similar way, referring to range D1:E100. In cell G1 Type OHIO and in cell H1 type Sales Tax. In cell I1 insert the following formula: =VLOOKUP(H1,INDIRECT(G1),2,0) You can link your drop down boxes to cell G1 and H1. Hope that solves your problem. -- Anant "GMAN501" wrote: I am working on a vlookuo formula and having trouble. I am trying to link the table_array portion of the vlookup to the selection made in a drop down box. Think of it this way...I have 50 tables set up, one for each state, if a person selects the state of Ohio from the list the table array will now have the name of Ohio seach only in that table. =vlookup(sales tax,result from drop down box, 2) if I type in =vlookup(sales tax, Ohio,2) I get the results I need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down boxes.. | Excel Discussion (Misc queries) | |||
drop down boxes | Excel Discussion (Misc queries) | |||
drop down boxes | Excel Discussion (Misc queries) | |||
drop down boxes | Excel Discussion (Misc queries) | |||
Drop Down Boxes | Excel Discussion (Misc queries) |