Drop Down - Partial Result from Selection

[miihj]

Similar to Drop Down thread: Drop Down (would simplify that one if this is possible)

Below is an example of what I'm looking at. Seeking a non macro solution to have drop down display as shown, but enters only the code portion, so if A: Apple was selected in C3 it would return A2=LEFT(A2,FIND(":",A2)-1). This would allow any "code" value before the colon and the description after.

View attachment 73840

 

[jasonb75]

I'm having difficulty making sense of what you're asking, but based on what it looks like:-

Whatever is selected from the dropdown list is what will appear in the cell. It is not possible to show anything different in that cell without using vba as was done in the other thread.

 

[gargamalebarbosa]

attachment is empty.. No pic.

 

[miihj]

Not sure why the image didn't stick, but here it is:

 

[miihj]

I'm having difficulty making sense of what you're asking, but based on what it looks like:-

Whatever is selected from the dropdown list is what will appear in the cell. It is not possible to show anything different in that cell without using vba as was done in the other thread.

This is what I was afraid of. I'm not familiar w/ VBA and tried to emulate the other thread w/ out luck.