Tazzy666uk
New Member
- Joined
- Jul 15, 2014
- Messages
- 19
Hi, It took me quite a while to work out one part of what i want, but could really do with some help now please
So, I have a drop down box with 4 'words' that someone selects:
Pre-school
School
Club
Other
What i want to happen is for someone to select one of these words and it bring up a price in another cell. I have another sheet that has costs in it along with other forms and boxes etc. For example
Pre-school =£5.00
School =£10.00
Club = £15.00
Other =£20.00
I created this for 'Pre-school' =IF(C7="Pre-School",Lists!H10,"") and it works.
I created this for 'School' =IF(C7="School",Lists!H11,"") and it works.
I created this for 'Club' =IF(C7="Club",Lists!H12,"") and it works.
I created this for 'Other' =IF(C7="Other",Lists!H13,"") and it works.
BUT...
How can i string them all together so that either 'word' returns the appropriate value within the same cell? I think this needs 'OR' in it somewhere but i am not clever enough to work it out!!
FYI - These costs can change quite often , which is why i have a single reference point in another sheet. I only have to change this figure, and the rest will change automatically.
I hope that makes sense?
Thanks in advance
Tazzy
So, I have a drop down box with 4 'words' that someone selects:
Pre-school
School
Club
Other
What i want to happen is for someone to select one of these words and it bring up a price in another cell. I have another sheet that has costs in it along with other forms and boxes etc. For example
Pre-school =£5.00
School =£10.00
Club = £15.00
Other =£20.00
I created this for 'Pre-school' =IF(C7="Pre-School",Lists!H10,"") and it works.
I created this for 'School' =IF(C7="School",Lists!H11,"") and it works.
I created this for 'Club' =IF(C7="Club",Lists!H12,"") and it works.
I created this for 'Other' =IF(C7="Other",Lists!H13,"") and it works.
BUT...
How can i string them all together so that either 'word' returns the appropriate value within the same cell? I think this needs 'OR' in it somewhere but i am not clever enough to work it out!!
FYI - These costs can change quite often , which is why i have a single reference point in another sheet. I only have to change this figure, and the rest will change automatically.
I hope that makes sense?
Thanks in advance
Tazzy