How can I fill a cell depending on another cell excel ?

Question

Example:

12 A
25 B
16 C

if in any cell i enter the number 12 i want the opposite cell to automatically give the letter B.
I have more the 100 numbers so i cant use the if() function.

Answer 1

You can do it without IF, although I couldn't understand you well.
But I can see what you are up to

mail me some more details about the cells addresses into Y! Answers

Enjoy my profile, I am the VBAXLMan

Answer 2

You must use the IF function but you can copy and paste it to the other cells. Your only other option is to use Visual Basic. You seriously can get it done with IF statements, just copy the formula and use the $ if you need to make a column or specific location static.

Formula
=if(CELLA=12,"B","")

you can replace the "B" with the value of another cell too. I'm kind of not sure what you were looking for in your question because you make no mention of C or maybe you mean that if A = 12 then B changes value to what C is. In that case replace the "B" part of the above formula to be the location of cell C. If you have 100 cells like this, just make it a vertically organized sheet and drag the bottom right corner of the cell with the formula down 100 cells.

Answer 3

You should use a vertical lookup.
Simply put a set of reference values (example in A1 through B5) in ascending order
20 E
40 D
60 C
80 B
100 A

Then put a value in a cell (example D1) and use the vertical look up in a different cell
=VLOOKUP(D1,A1:B5,2)

D1 is the value to lookup
A1:B5 is the reference values from the first part
2 states that the value you are interested in is the second value

Answer 4

flow to format and the selected conditional formatting. you'll likely favor to have the red/Amber/eco-friendly cells repeat the determination from the reference cells, yet you are able to condition the font coloration so the determination gained't coach. if there is something else e-mail me.