I am stuck...

[DarrenPWS]

I have been asigned an ICT project at college and I have lost an
knowledge I once had when it comes to using MS Excel.

To be brief, I have to have one field that will display a pric
according to which payment category has been entered in a differen
field.

The Categories are:
U12 - £5.00
12-18 yrs - £7.00
Adult - £12.00
OAP - £9.00

If 'OAP' is entered into one field, the price of £9.00 wil
automatically be entered into the other field.

If 'Adult' is entered into one field, the price of £12.00 wil
automatically be entered into the other field - etc.etc.

Please can you help me - I don't have a clue what function I should us
for this !?

 

[Bob Phillips]

Take a look at the lookup functions in help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi Darren!

One way:
=VLOOKUP(A1,{"U12",5;"12-18 yrs",7;"Adult",12;"OAP",9},2,0)

If you want it to return "" pending data entry:

=IF(A1="","",VLOOKUP(A1,{"U12",5;"12-18
yrs",7;"Adult",12;"OAP",9},2,0))

And it will return #N/A if someone enters a non acceptable string.

Better, might be to consider data validating the entry to the cell
looked up.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.