cell to equal based on multiple data validation options

[jimjim001]

Im trying to do something simple, I think... and im stuck.

A1 has 4 drop down options.
I want B1 to read either C1, C2, C3 or C4 based on the drop down selected in A1

So like this.
if I select P1 in the drop down at A1, then B1 would read C1, and show "5"
if I select P2 in the drop down at A1, then B1 would read C2, and show "10"
if I select P3 in the drop down at A1, then B1 would read C3, and show "15"
if I select P2 in the drop down at A1, then B1 would read C4, and show "20"

Screenshot attached for reference

Help please!

TIA.

 

[BigBeachBananas]

I don't think you need column C. Unless you're changing C. But try this:

Book1.xlsx
	A	B	C
1	P4	20	5
2			10
3			15
4			20
Sheet8

Cell Formulas
Range	Formula
B1	B1	=IFS(A1="P1",C1,A1="P2",C2,A1="P3",C3,A1="P4",C4,TRUE,"")

Cells with Data Validation
Cell	Allow	Criteria
A1	List	P1,P2,P3,P4

 

[jimjim001]

I don't think you need column C. Unless you're changing C. But try this:

Book1.xlsx
	A	B	C
1	P4	20	5
2			10
3			15
4			20
Sheet8

Cell Formulas
Range	Formula
B1	B1	=IFS(A1="P1",C1,A1="P2",C2,A1="P3",C3,A1="P4",C4,TRUE,"")

Cells with Data Validation
Cell	Allow	Criteria
A1	List	P1,P2,P3,P4

legend!

C may change over time, so will keep it there. Thanks heaps!

 

[jimjim001]

actually, it didnt work

 

[BigBeachBananas]

Why is it not working?

 

[jimjim001]

Why is it not working?

im not sure. Its in google sheets. Maybe there is a difference?

 

[jimjim001]

GOT IT WORKING!

The formula looked a little different in the end, it was this:

=IFS(E8=1,$J$132,E8=3,$J$129,E8=6,$J$126,E8=12,$E$129,E8=18,$E$126,E8="","")