Drop-Down List Explosion

[dbert]

Have a 7-Line drop-down list (Cell No., Home Phone, Address, etc.), and need following cell to display the info. selected from that drop-down list. Not an Excel Expert...please advise! Thx!

[NBVC]

I think you are going to need to elaborate a bit.

...so you select from a dropdown and what exactly is supposed to appear in the next cell and where does that data come from?

[dbert]

Can I somehow put conditions in 'C5' to say (if 'C4' = Phone No.), then 123-456-7890 appears in 'C5', (if 'C4' = Phone Ext), then x9876 appears in 'C5'. Would something like this even be possible?...and if possible, at all easy? Thx!

[NBVC]

Is this data listed somewhere else in the workbook or is there only one possible result for each category?

If there is a list...you can use Vlookup() to get result.

e.g. =Vlookup(C4,X1:Y7,2,0) will lookup C4 in list in X1:X7 and return corresponding item from Y1:Y7

If not, then you can use a Nested IF (but only maximum of 7 nested if's)...

e.g. =IF(C4="Phone No.","123-459-7890",IF(C4="Phone Ext.","x9876",IF(C4=...etc.).

[dbert]

I'll give these a whirl....Thank you for your help!!!!!!!!!