I am creating a invoice for an Theatre to calculate price of ticket based on
location(Balcony, Orchestra) and series (A, B, C. D. E. F). How do I get the
ticket price to display the correct price based on the two factors above?

Ex.

# of seats: 4
Series: A
Location: Balcony

Balcony prices a 100, 200, 300
Orchestra prices a 400, 500, 600

I can only get it to come up with the correct answer for Orchestra or
Balcony but not both.

My formula is as follows: =VLOOKUP(Series,PriceTable,2)*NbrTickets