If one cell equals "Value", then the cell the formula is in equals "figure", for multiple value options

[Outlook12]

Hi, I wanted to craft a formulae that would allow me to do the following:

If A1 = "black", then the cell would equal 20, If A1 = "green", then the cell would equal 50, If cell A1 = "blue", then cell would equal 15, etc.

Thank you,

 

[Peter_SSs]

Welcome to the MrExcel board!

You could do it like I have in column B but more common and easier to edit or maintain is to have a lookup list and use one of the available lookup functions as I have done in column C.

24 04 08.xlsm
	A	B	C	D	E	F
1	green	50	50		black	20
2	black	20	20		green	50
3					blue	15
4
5
Lookup 3

Cell Formulas
Range	Formula
B1:B2	B1	=IF(A1="black",20,IF(A1="green",50,IF(A1="blue",15,"")))
C1:C2	C1	=XLOOKUP(A1,E$1:E$10,F$1:F$10)

 

[Outlook12]

Welcome to the MrExcel board!

You could do it like I have in column B but more common and easier to edit or maintain is to have a lookup list and use one of the available lookup functions as I have done in column C.

24 04 08.xlsm
	A	B	C	D	E	F
1	green	50	50		black	20
2	black	20	20		green	50
3					blue	15
4
5
Lookup 3

Cell Formulas
Range	Formula
B1:B2	B1	=IF(A1="black",20,IF(A1="green",50,IF(A1="blue",15,"")))
C1:C2	C1	=XLOOKUP(A1,E$1:E$10,F$1:F$10)

Thank you so much!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.