excel help please

Colbaker · 5 Jun 2010 at 13:49

hi all, what i want to do is create a drop box with many different names in it (this i can do), but when i use the drop box to select a specific name i want the cell next to it to auto enter a number that is specific to that name i.e. the persons age, any idea what formula to use?

TheKnat · 5 Jun 2010 at 14:07

I'm assuming that the details you want it to auto enter will be stored in a separate worksheet?

If so you can use the VLOOKUP feature, such as =VLOOKUP(A1,Sheet2!A1:C2,3,TRUE). That checks that value of cell A1, then looks up in sheet2 between A1 and C2 for that result and outputs the 3 column as the result.

Colbaker · 6 Jun 2010 at 14:20

Thank's for the reply but i cannot get that to work, I will explain a little better what i want to do..........

On sheet 1 i have a list of names in column G and a list of Ages in Column E, see below..

And i have created a drop box and chosen the name Carly (for instance) but want the AGE cell to auto add her age from the data pool above but have no idea how to do it, please help, i am a novice to excel.

Pho · 6 Jun 2010 at 14:33

What TheKnat suggested is what you need to do - http://homepages.nildram.co.uk/~akiller/OcUK/files/Colbaker/Colbaker.xlsx tada

.

Colbaker · 6 Jun 2010 at 18:31

Thanks muchly for that.