Ask Your Question
0

I need drop down list help

asked 2018-09-01 02:51:00 +0200

Todd2 gravatar image

Calc,

I want to have "column A" loaded with folk's names and "Column B" loaded with there ages.

Then I want a cell off to the right with a pull down showing the names in column A. When selecting a name from the pull down, it fill in their age from column B.

How do I do this?

Many thanks, -T

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-09-01 04:07:41 +0200

Todd2 gravatar image

I need to use a formula like

=VLOOKUP($F$2,$A$2:$B$5,MATCH(B1,$A1:$B$1,0),0)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-01 02:51:00 +0200

Seen: 38 times

Last updated: Sep 01 '18