Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have products listed on "products" page that are in column A2 through A800.
For each product I have a cost column in Column C. Columns G through L contain a dollar amount showing an amount of selling price. Columns G through L represent whether a product is sold at a 10,15,20,25,35 or a 42 % margin. I have a "Main Quote page 1" that has in column E18 through E58 drop down boxes that allow me to lookup the list on the "products" page. I want to create a drop down box on the "Main Quote page 1" in Column N a drop down list that will give me all of the choices of the percentage amounts from the products page. ex: Products page A C G H I J K L product Cost 10% 15% 20% 25% 35% 42% 15-0-15 12.95 14.39 15.23 16.19 17.27 19.92 21.58 16-4-8 8.75 9.72 10.29 10.94 11.67 13.46 14.68 28-0-12 12.25 13.89 14.71 15.62 16.67 19.23 20.83 Any suggestions? Thanks ahead of time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup & hlookup | Excel Worksheet Functions | |||
VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
VLOOKUP/HLOOKUP | Excel Discussion (Misc queries) | |||
How do I use Vlookup or Hlookup? | Excel Discussion (Misc queries) | |||
Vlookup and Hlookup | Excel Worksheet Functions |