VLOOKUP question concerning population a price
Ok then. Here are several hints (^:
First, you know that VLOOKUP requires a single column of values to serve
as a "key", right? But you have /two/ criteria that make up the key
(Seating and Age). What to do? Here's what...
Revise the little table in Sheet1 so it looks like this:
A B C D
Seating Age Key Price
Floor 18OO ? 30
Floor U18 ? 20
Balcony 18OO ? 15
.....
The first formula ? is
= A2&B2
Now, in Sheet2, you also have columns for
A B C D
Seating Age ... Price
Can you see what to do next?
N.B. I changed the Age values to simplify thing a little.
DLL wrote:
Thanks that seems to work, but I really need to use the VLOOKUP formula. It's
for a class. Not the exact problem but similar. Thanks for any help
"smartin" wrote:
DLL wrote:
I meant to type "Population a price"
"DLL" wrote:
If I had a seat list and price list according to age;
Lets say 18 and over is $30.00 and under 18 is $20.00 that is for a floor
level seat. A balcony seat is $15.00 if you are 18 and over. It is $10.00 if
you are under 18. Then you have a front row seat that is $40.00 dollars if
you are 18 and over and $35.00 if you are under 18.
I have to determine the price according to age and seat selection.
Any help is sure appreciated I am missing some step but can not figure out
where. I hope I have given enough information. If not let me know...THANKS
One way:
Make a little table like this in Sheet1!A1:C4
18+ under 18
Floor 30 20
Balcony 15 10
Front Row 40 35
In Sheet2 set up column labels and search criteria, e.g.:
Seating Age Price
Balcony under 18 ?
The ? formula in C2 is
=INDEX(Sheet1!$B$2:$C$4,MATCH(Sheet2!A2,Sheet1!$A$ 2:$A$4,0),MATCH(Sheet2!B2,Sheet1!$B$1:$C$1,0))
|