I cannot be this stupid.

[sheikah]

There is a way to do a formula in Excel where like, if one cell equals a certain word, it puts a number in the cell you put the formula in?

NOTHING I HAVE TRIED HAS WORKED.

Comments

[alchemy]

Have you used an IF formula?

[sheikah]

I haaaaaave and they keep failing no matter what I do. I'm just going to enter it manually and move on to the next problem - obviously this will take less time

[alchemy]

This person has basically answered your question, but I've got no idea if it will actually work.