Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and its properties | Excel Worksheet Functions | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |