Formula Issues I\'ve been struggling with coursework in college again. I justt n

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

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.