What i would like to do is create a drop down box with codes #'s. Then when i
click on the code # the definition of the code would appear in the next cell.
Is that possible?

With your droplists in A2 down
you could place something like this in B2, copied down:
=IF(A2="","",VLOOKUP(A2,{"code1","Defn1";"code2"," Defn2";"code3","Defn3"},2,0))

Or, if you have the mapping table for codes to definitions
listed in say, Sheet2's cols A and B from row1 down
then you could use in B2, copied down:
=IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"doss04" wrote:
What i would like to do is create a drop down box with codes #'s. Then when i
click on the code # the definition of the code would appear in the next cell.
Is that possible?

I"m really new to excel. I need to know where to type the formula at? A
little step by step if possible. Thanks


"Max" wrote:

With your droplists in A2 down
you could place something like this in B2, copied down:
=IF(A2="","",VLOOKUP(A2,{"code1","Defn1";"code2"," Defn2";"code3","Defn3"},2,0))

Or, if you have the mapping table for codes to definitions
listed in say, Sheet2's cols A and B from row1 down
then you could use in B2, copied down:
=IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"doss04" wrote:
What i would like to do is create a drop down box with codes #'s. Then when i
click on the code # the definition of the code would appear in the next cell.
Is that possible?

Try looking here for further guidance:

http://www.excel-examples.com/excel-...down-lists.htm

"doss04" wrote:

I"m really new to excel. I need to know where to type the formula at? A
little step by step if possible. Thanks


"Max" wrote:

With your droplists in A2 down
you could place something like this in B2, copied down:
=IF(A2="","",VLOOKUP(A2,{"code1","Defn1";"code2"," Defn2";"code3","Defn3"},2,0))

Or, if you have the mapping table for codes to definitions
listed in say, Sheet2's cols A and B from row1 down
then you could use in B2, copied down:
=IF(A2="","",VLOOKUP(A2,Sheet2!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"doss04" wrote:
What i would like to do is create a drop down box with codes #'s. Then when i
click on the code # the definition of the code would appear in the next cell.
Is that possible?

.. need to know where to type the formula at?
A little step by step if possible.

but, but ... wasn't the above explained quite clearly in my response? In B2?
Pl re-read the response carefully

A general point. Don't re-type formulas given. You're likely to introduce
errors. Just copy the formula(s) direct from the response, then paste
directly into the formula bar for the cell(s) as mentioned in the response.
Prior to posting, the formulas would have been tested in order by the
responder. You should, of course, note the set-up assumptions (sheetnames,
etc) -- these assumptions would be stated in the response -- and ensure that
these are replicated in your book before doing the direct copy n paste.

You might want to review some basics at Debra's:
http://www.contextures.com/xlDataVal01.html
Excel -- Data Validation -- Introduction

http://www.contextures.com/xlFunctions02.html
Excel -- Worksheet Functions -- VLookup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---