Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help....PLEASE!
Hi, I'm trying to figure out how to figure out how to calculate ticket cost
using Vlookup.... Here's how the question was put to me: Compute ticket cost (cell J12) as price per ticket * number of season tickets. To determine the price per ticket use the Vlookup function and the series price table (A15:A20), series (B8), and location (B9) fields. I'm literally banging my head on my desk trying to figure this out...your help would be desperately appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help....PLEASE!
See this screencap:
http://img367.imageshack.us/img367/3941/lookupir2.jpg Biff "Lhsquared" wrote in message ... Hi, I'm trying to figure out how to figure out how to calculate ticket cost using Vlookup.... Here's how the question was put to me: Compute ticket cost (cell J12) as price per ticket * number of season tickets. To determine the price per ticket use the Vlookup function and the series price table (A15:A20), series (B8), and location (B9) fields. I'm literally banging my head on my desk trying to figure this out...your help would be desperately appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and its properties | Excel Worksheet Functions | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |