F
Fran
i want to use VLOOKUP to figure out the price of a ticket.
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????
i have to find the series (b8) the find the location (b9) and then use theb7 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
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????