VLOOKUP HELP

[Fran]

i want to use VLOOKUP to figure out the price of a ticket.

b7 is nbr of tickets
b8 is ticket series
b9 is the location of the seat

cells a15:c20 is the price chart example
series level 1 level 2
a $10 $5
b $15 $10

i have to find the series (b8) the find the location (b9) and then use the
price chart (a15:c20) to find the price.

once i find the price of the ticket in the chart, i have to multiply it by
(b7) the number of tickets. any help????

 

[Guest]

Assuming your table headers are in A15:C15 and your row descriptions are in
A15:A20:

=B7*INDEX(A15:C20,MATCH(B8,A15:A20,0),MATCH(B9,A15:C15,0))