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