FORMULA

[Karoline]

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 rows
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?????

 

[Karoline]

Once again, sorry:

 

[Bob Phillips]

=VLOOKUP(A2,M1:N14,2,False)

where M1:N14 is your table

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JLatham]

In B1 use this formula:
=VLOOKUP(A1,$H$1:$J$14,3,FALSE)
That's based on the information you gave, but I think you may have made a
mistake and that your table is in H and I not, H, I and J. If it is in H and
I, then the formula would be
=VLOOKUP(A1,$H$1:$I$14,2,FALSE)
You can then fill that formula down your sheet and the A1 will change to A2,
A3, A4, etc. while the rest of it will remain as it is now and keep working
in each cell.

Hope this helps some.

 

[DILipandey]

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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India