SET VALUE in EXCEL

[fabby1]

Hi I am trying to set values to words for example the word day would have a value of 5 and the word Night would have a value of 12 and so on. Then I would need to add the words to get the total value.

Example:

Column1 Column2 Total
Day Night 17

 

[TonyJollans]

Hi fabby1,

How does day equate to 5 and night to 12? Do you have a table to look the values up in, or some sort of algorithm?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[cranebill]

Have you looked into the vlookup function?