Hi Karoline,

Assuming that you have used range A1 to B10 for defining your categories and
abbreviations, use following formula in the right side of the cell where u
have entered the category. What it will do, it will automatically pick up
the respective abbreviation. Thanks.

=VLOOKUP(A23,$A$1:$B$10,2,0)

Please click on "Yes" if it works.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Karoline" wrote:

Once again, sorry:

I am a dummy in Excel and would appreciate someone's help on this:

I made in a corner of my Worksheet an explanatory table with 2 COLUMNS
indicating categories and abbreviations as follows:

H1 J1
1 i
2 rtvs
3 cpl
4 sgl
H5 J5
and so on. They are 14 categories each one with its respective abbreviations

What I need is to introduce a formula in such a way that in the space for
the answers of a questionary in a lower part of the Worksheet, every time I
enter in the empty cell the assigned category, the abbreviation could appear
in the next empty cell automatically.

example:
A1 Category Number B1 abreviation
4 then here it comes automatic the proper
abreviation

While reading I found that maybe I should use Vlook up, or IF but I have
more than 7 categories and I couldn't figure out a proper formula... Some one
patient enough around to give me a hint?????

--
KBZ