ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with science

Wed
May 12
2010

In Excel 2007, how do I make specific number values correspond to specific text values?

I'm trying to create a template for entering social science questionnaires, and SPSS has spoiled me. When I start entering the data, I want to able to type numbers and then have the correct text fill the box. For example, one question concerns race. I want to be able to type "1" and have "caucasian" automatically appear in the box. However, I want to RETAIN the number values so that I can easily run statistical analyses. Can Excel do this? Someone please help!


Answer

Yes, it can
This called VLOOKUP function, it is very popular and widely used

Here is a lesson on how to do that
http://www.vbaxlman.com/Lessons/?ID=b1vi…

VBAXLMan

Wednesday 5/12/2010 8:55:57 PM

Tags

History