Drop-down selection automatically enters next cell?

[olivierlala]

Hi,
I have a simple question. I am working with one drop-down list containing projects name and I would like Excel to automatically enter the next cell’s content which corresponds to the project type once the project is chosen from the list.
Anyway to do that?

Thanks a lot,
Oli

[ratcat]

G'day and welcome to the forum,

First you'll need a list of the 'Projects' with the list of 'Project type' next to it

Example

Please Login or Register  to view this content.

Then use the Vlookup formula to collect the required result.

If the data validation (drop down list) is located at cell D5 and you need the corresponding information at E5 you can write the vlookup formula like this.

=VLOOKUP(D5,Y1:Z5,2,FALSE)

HTH

RC

[olivierlala]

Perfect, thanks a lot for the answer!