contents of cell is based on what I choose in a drop down menu

[damolee]

Hi there,

I have attached an excel file so you very helpful guys can maybe help me!

In Cell A2, I have a drop down list option where I can choose from a set of players. The players are displayed using Data - Validation, and are stored further down the page.

The first player is stored in cell A100 and in cell B100 is the players height.

The problem I have is that when a user selects a player in the drop down lists, I want to display his height in the Height column - so if I select Manual Almunia in the drop down list, then 6ft0 would need to be displayed in the Height cell in the same row

Any ideas people?

Thanks

Damien.

[barrfly]

try using a vlookup for the height. this is the formula i put in the height column (cell c2)


=VLOOKUP(A2,$A$100:$B$113,2,FALSE)

[damolee]

thanks Barryfly, that worked perfectly!