LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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.
 
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
Vlookup & hlookup Aitchy Excel Worksheet Functions 3 May 29th 07 05:10 AM
VLOOKUP & HLOOKUP sahafi Excel Worksheet Functions 1 January 3rd 07 11:19 PM
VLOOKUP/HLOOKUP MsNadi Excel Discussion (Misc queries) 1 February 10th 06 07:44 PM
How do I use Vlookup or Hlookup? exsam21 Excel Discussion (Misc queries) 2 September 23rd 05 07:26 PM
Vlookup and Hlookup Phlogiston2312 Excel Worksheet Functions 1 April 21st 05 04:59 PM


All times are GMT +1. The time now is 06:23 PM.

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"