| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Function
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can we use multiple if with VLookup function | Excel Worksheet Functions | |||
| vlookup Function Help Needed | Excel Worksheet Functions | |||
| Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Vlookup w/Date Function | Excel Worksheet Functions | |||
Threaded Mode
