Index / Match

[The Grim Discovery]

Animal	Phobic
Rat	Yes
Snake	No
Spider	Unknown
Scorpion
Rat	?
Snake
Rat	?
Spider

<tbody>
</tbody>

Hello, how do I get all instances in Col A of 'Rat' to show in Col B as "yes"? This needs to be dynamic as the Col B could also be "no". I suppose I'm asking how can value in Col A have its associated value in Col B repeated wherever it is found? I'm INDEX/MATCHING myself to a standstill.

Thanks in advance.

 

[Gerald Higgins]

How are you determining that the first value for "Rat" is actually "Yes" ?
Are you just manually typing this into Col B ?
Or is this information held somewhere else ? (this would be my preferred solution I think)

 

[oldbrewer]

Animal	Phobic
Rat	Yes
Snake	No
Spider	Unknown
Scorpion	yes
Rat	yes
Snake	no						mytable
Rat	yes
Spider	unknown						bat	no
bat	no						bee	yes
bee	yes						rat	yes
bat	no						scorpion	yes
							snake	no
							spider	unknown
		the yes by scorpion derived by
		=VLOOKUP(A6,mytable,2)

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

GIVEN
Animal	Phobic
Rat	Yes
Snake	No
snake	Unknown
scorpion	yes
							mytable
							bat	no
							bee	yes
							rat	yes
							scorpion	yes
							snake	no
							spider	unknown
		the yes by scorpion derived by
		=VLOOKUP(A6,mytable,2)
Scorpion	yes
Rat	yes
Snake	no
Rat	yes
Spider	unknown
bat	no
bee	yes
bat	no

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[The Grim Discovery]

thanks chaps - really helpful stuff.