Which formula do I need?

[charlie.94]

I have a basic and working knowledge of excel (really basic data input), but I'm not sure where to start, or if it's possible in excel.

Basically, I'm trying to create something in excel that will return a written value as a result of a drop down list selection.

To be more specific, I want a drop down list of different types of phones. Once a phone has been selected, I want it to display what size sim card the phone uses.

Drop down lists aren't a problem, but I don't know how to feed a text result from it.

Help welcome and thankfully received!

 

[Somendra Misra]

Hi Charlie,

Welcome to the forum.

See the attached file. Yellow cell has dropdown and cell next to it is giving sim type. This is a basic idea based on your explanation.

Regards,

 

[charlie.94]

That's perfect! Thank you so much. Never particularly understood vLookup, so I'm really grateful.

Thanks again!

 

[Somendra Misra]

Today is VLOOKUP day for me since morning

You are welcome!!!

Regards,