LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default help with vlookup

Help - I need to compute a formula to determine the price of a ticket. Cell H5

In Cell b1 is # of tickets needed
In cell B2 is drop down list for the type of seating ranging from A - F -
this field is also labled Series
In cell B3 is a Drop down list asking for Location - with two choices Upper
or Lower - this field is Called Location

In a named Range A14 - C21, called Price Table, is the array of info as
follows
a14 - Series - b14 - Upper - C14 - Lower
a15 = A b15 = 170 c15 = 225
a16 = b b16 = 120 c16 = 220
a17 = c c16 = 100 c17 = 190

etc.......

I thought I could use Vlookup - but I keep receiving an error

what formual can I use that I would insert into Cell H5 - that would look at
cell B2 and distinguis which type of series is selected
then Look in cell B3 to look at the Location
Then to find that information from the table

and then multiply it by cell b1, the number of tickets needed.

I hope I explained this correctly. It should be easily done - I don't know
what I am doing wrong.

Thanks


 
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 and its properties pepenacho Excel Worksheet Functions 1 August 22nd 06 10:52 PM
VLookup a Vlookup adamb2000 Excel Worksheet Functions 4 June 28th 06 10:54 PM
VLOOKUP Problem Ian Excel Discussion (Misc queries) 3 April 6th 06 06:47 PM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM


All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"