What is the correct formula "Refers to:"? (I want to display values on column C IF cell in column B is Green but instead it displays a 10)

[arthurz11]

 

[Snakehips]

@arthurz11

Your refers to is correct hence you are getting the return of B colour in C.
You then need formula in C to retrieve A value based on colour value.

AutoTraining.xlsm
	A	B	C
1	1
2	2
3	3		3
4	4
5	5
6	6		6
7	7		7
8	8
9	9		9
10	10
11
12
Sheet6

Cell Formulas
Range	Formula
C1:C12	C1	=IF(checkcolor=10,A1,"")

 

[Fluff]

Duplicate to: How do you write an IF formula in Cell C2 base on the condition of Cell B2?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.