using a list box
 

is it possible to use a drop down list as a selector of diferent cal
process

senario: lets say we need to make a booking form very obvious so t
lesson mistakes espeacilly on the finacial side , the list boxes w
have are 1 selecting tariff band a,b,or c ...another selectin
categories...and the third selecting costs £5,£10,£15 obviously ther
are a few cobinations that could be achived using the list but what
need to do ,

when the right combination is matched then the cost (or a separat
cell) will flag and i need to do this on all three

tariff (a) costs (£5) category (charity) ....this being the correc
combination a flag happens somhow (once the flag is seen the chargin
combination is correct

tariff (b) cost (£10) category (corparate) this also is correc
combination

tariff (c) cost (£15) catogory (confrence room) this is correc
combinatio

not sure this can be don

--
kevat
-----------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...fo&userid=3024
View this thread: http://www.excelforum.com/showthread.php?threadid=50692

using a list box
 

You would need to have all the valid combinations someplace and then check
them using match

=isnumber(Match(A1&B1&C1,Sheet1!$A$1:$A$50&Sheet1! $B$1:$B$50&Sheet1!$C$1:$C$
50,0))

Will return true if the combination in A1, B1, C1 is found in the columns A,
B, C in sheet1. This is an arrayformula. If you use it in a cell, it must
be entered with Ctrl+Shift+Enter rather than just enter.

Debra Dalgleish
http://www.contextures.com/tiptech.html

has information on Dependent Dropdowns (under Data=Validation) and a lot of
other methods which might assist you.

--
Regards,
Tom Ogilvy


"kevatt" wrote in
message ...

is it possible to use a drop down list as a selector of diferent calc
process

senario: lets say we need to make a booking form very obvious so to
lesson mistakes espeacilly on the finacial side , the list boxes we
have are 1 selecting tariff band a,b,or c ...another selecting
categories...and the third selecting costs £5,£10,£15 obviously there
are a few cobinations that could be achived using the list but what i
need to do ,

when the right combination is matched then the cost (or a separate
cell) will flag and i need to do this on all three

tariff (a) costs (£5) category (charity) ....this being the correct
combination a flag happens somhow (once the flag is seen the charging
combination is correct

tariff (b) cost (£10) category (corparate) this also is correct
combination

tariff (c) cost (£15) catogory (confrence room) this is correct
combinatio

not sure this can be done


--
kevatt
------------------------------------------------------------------------
kevatt's Profile:
http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=506926