Formula Issues I\'ve been struggling with coursework in college again. I justt n
ID: 3571050 • Letter: F
Question
Formula Issues
I've been struggling with coursework in college again. I justt need something that can do what is stated below::
If you have a look at the images below, it may explain things easier.
Basically, I need a formula that will input a numerical value down the column L in Ticket Holder Details. This value would be found by having a look at the Column to the left of it and seeing if it says Adult, OAP, Child, VIP. From this, it would then have a look at the season ticket type details sheet, from there, it would look down the column of D until it finds the matching word; like adult. It would then look two cells over and grab that price and transfer it back over to the first sheet.
If I need to explain in any more details, just post below. I'm also aware that I'm using the mac 2011 in this screenshot, well, it doesn't matter as I use Windows 7 and office 2010 anyway on PC.
Thanks,
IGGShaun.
"Ticket_Holder_Details" Sheet
"Season_Ticket_Type_Details" Sheet
Formula Issues I've been struggling with coursework in college again. I justt need something that can do what is stated below:: If you have a look at the images below, it may explain things easier. Basically, I need a formula that will input a numerical value down the column L in Ticket Holder Details. This value would be found by having a look at the Column to the left of it and seeing if it says Adult, OAP, Child, VIP. From this, it would then have a look at the season ticket type details sheet, from there, it would look down the column of D until it finds the matching word; like adult. It would then look two cells over and grab that price and transfer it back over to the first sheet. If I need to explain in any more details, just post below. I'm also aware that I'm using the mac 2011 in this screenshot, well, it doesn't matter as I use Windows 7 and office 2010 anyway on PC.Explanation / Answer
Hi..
In L6 of "Ticket_Holder_Details" Sheet, type:
=vlookup(if(K6="VIP", "VIP - Seatingg G", K6 &" - Seating A"), Season_Ticket_Type_Details!$D$6:$F$28,3,0)
and then autofill the rest of the cells