Using Data from dropdown list

[zhuangzi]

Hi all,
Need a favor.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Risk Profile[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Low [/TD]
[TD]Medium[/TD]
[TD]High[/TD]
[TD][/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Risk Appetite[/TD]
[TD]Low[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


I like to have the Score (Cell G4) displayed based on selection made in Cell B4. Example if User choose "Low", Score = 1

Many thanks in advance.

 

[Robby19]

Place in G4 and copy down as required;

=IF(B4="Low",1,IF(B4="Mid",2,IF(B4="High",3,"")))

This accounts for low, mid (medium) and high. Change to suit your needs.