HELP. Im a newbie.

D

dbledeez

i know that this is probably really easy but im a newbie. i searched all
over the forums for this. anyways.
i have a drop down menu and i have a cell on the screen that displays
whatever the drop down menu says. now the drop down menu has initials
like MD812 or DG811 that needs to be like that becuase it fills in
initails in another spot for an issue or a pickup of money. What i want
to happen is when i have the drop down menu on lets say MD812 it would
read Michael Diedrich instead of MD812.
like If the drop down menu equals DG811 than display Dave Gault and so
on and so on. anybody get what im saying?
 
V

VBA Noob

Why don't you just use the name in the list and then do the formula o
the name or add a column next to the drop down list and do a lookup.

If you post an example it would be good

You can post on the below link

http://cjoint.com/

VBA Noo
 
D

Dave Peterson

I think I'd leave the dropdown along.

If the dropdown was made by data|validation, then you could use an adjacent cell
to show that long name.

I'd create a table (on a different worksheet--maybe hidden), then use a formula
like:

=if(a1="","",vlookup(a1,sheet2!a:b,2,false)

to return the long name.

===
If you used a different technique to create that dropdown, share the details--a
combobox from the Control toolbox toolbar or a dropdown from the Forms
toolbar????

You could use the linked cell and the same kind of formula.
 
Top