Vlookup vs Hlookup or Both?
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.
|