autofill cell depending on text in another cell

[Acehole]

hello all, the noob is back for help if possible.
I have a cell (A13)that is populated by drop down list. the text reads for alternative treatment
if cell A13 has the word alternative in it I would like cell E13 to autofill with the numbers 180103* if that is possible
hope that makes sense
regards
acehole

 

[Acehole]

hello,
what can I say aside from thank you very much
lots of us would be sunk if it were no for your assistance
thanks again
acehole

 

[Acehole]

hello, i'm back for more, I may be pushing my luck now though.
is there a way for it to look at the first 2 words entered then make the selection?
thanks
acehole

 

[Peter_SSs]

hello, i'm back for more, I may be pushing my luck now though.
is there a way for it to look at the first 2 words entered then make the selection?
thanks
acehole

Not clear to me. Examples please.

 

[Acehole]

Hi peter, thank you for your patience with me.
the formula you gave me works fine until I have a duplicate word appearing in the cell it is looking at. This could occur again
so if cell A13 has the the text "hazardous chemical"waste lq . then E13 populates with 180103
if cell A13 has the text "anatomical waste"potentially contaminated with formalin. then populate E13 with 180108
the first 2 words in the cell to be looked for there will be no speech marks.
hope that is a bit clearer
thanks
acehole

 

[Peter_SSs]

Does that mean the lookup list (what I had in column J in my layout) are all two words too?
Or are some/all of the column J entries single words which could occur as the first or second word in A13?

 

[Acehole]

Hello, yes the look up list will be 2 words, the entries in column J could occur anywhere in it, not only in the first 2 words,
that where I have had difficulties, your original help works great, but the chance of duplicate words was there and this was giving a 0 result. So if I look at the first 2 words these should always be different, hopefully
regards
acehole

 

[Peter_SSs]

yes the look up list will be 2 words, the entries in column J could occur anywhere in it, not only in the first 2 words,..

Then from what I can make of that, my existing formula does that.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
2										hot day	180103
3										two words	180108
4										offensive odour	180104
5
6
7
8
9
10
11
12
13	this has more than two words				180108
14
Acehole

If this is not what you meant then please make up a small dummy set of data for the list I have in columns J:K (3 items like I have should do).

Then give me 5 clear examples of what might be in A13 and the answer you would expect for each of those 5 examples. Make sure some of the examples have something from the lookup list and some don't.

 

[Acehole]

hello thanks for your continued help infectious healthcare waste for alternative treatment 180103* sharps contaminated with non hazardous medicines 180103* cytotoxic waste may contain potentially infectious material 180108* hazradous waste for incinertation 180103* offensive waste 180104 hazardous chemical waste 180106* anatomical waste potentially contaminated with formalin solution 180106* amalgam contaminated waste 180110* dialysis waste may contain potentially contaminated material 180103* packaging contaminated with hazardous chemicals 180106* potentially infectious waste contaminated with chemicals 180106* these are the what could be in the list and the numbers required, thanks acehole dont why it has bunched text togather soryr​

<TBODY> </TBODY>

 

[Peter_SSs]

I can't make any sense of that. My signature block below has suggestions for posting small screen shots. You can see from my previous posts that it not only shows the data clearly, but also exactly what cells it is in.

 

[Acehole]

hello again, tried using the html thingy but was less readable than this ?
TEXT NUMBER REQUIRED Infectious healthcare waste for alternative treatment 180103 Sharps contaminated with non-hazardous medicines 180103 Cytotoxic waste (may contain potentially infectious material) 180108 Non hazardous waste medicines 180109 Infectious healthcare waste for incineration 180103 Offensive waste 180104 Hazardous chemical waste LQ 180106 Anatomical waste (potentially contaminated with formalin solution) 180103 amalgam contaminated waste 180110 dialysis waste (may contain potentially infectious material) 180106 packaging contaminated with hazardous chemicals 180106 potentially infectious waste contaminated with chemicals 180106 <tbody> </tbody><colgroup><col><col><col></colgroup>
hope this is clearer I will try to use the formats you suggested when I can make it work
regards
acehole

<tbody>
</tbody><colgroup><col><col><col></colgroup>

<tbody>
</tbody><colgroup><col><col><col></colgroup>