Create a worksheet that allows a person to enter in an age and a ticket location, and automatically gives the price of the ticket.

If the user enters an illegal location the worksheet should put an error message in the cell.


Cant figure out the formula
i have made the lookup table and columns are sorted in order

i used a scroll bar for the age and a radio button for the 4 ticket locations.

Please help driving me nuts