F
Fran
in cell h13, i want to use vlookup to figure out the price of a ticket.
once i find the price of the ticket in the chart, i have to multiply it by
b7. any help????
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
once i find the price of the ticket in the chart, i have to multiply it by
b7. any help????
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