using a list box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevatt - 31 Jan 2006 20:28 GMT

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

Reply to this Message

Tom Ogilvy - 31 Jan 2006 22:06 GMT

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.

Signature

Regards,
Tom Ogilvy

> is it possible to use a drop down list as a selector of diferent calc
> process
[quoted text clipped - 20 lines]
>
> not sure this can be done

Reply to this Message