Using Data from dropdown list

[zhuangzi]

Hi all,
Need a favor.

	A	B	C	D	E	F	G
1
2	Risk Profile
3			Low	Medium	High		Score
4	Risk Appetite	Low	1	2	3		1

<tbody>
</tbody>

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.