HELP. Im a newbie.

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?

Why don't you just use the name in the list and then do the formula on 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 Noob

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.

dbledeez wrote:
>
> 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?
>
> --
> dbledeez
> ------------------------------------------------------------------------
> dbledeez's Profile: http://www.excelforum.com/member.php...o&userid=36548
> View this thread: http://www.excelforum.com/showthread...hreadid=568674

--

Dave Peterson