Link to home
Start Free TrialLog in
Avatar of dlan75
dlan75Flag for France

asked on

Excel, select proper data

Hi all,

Ok here is what I want to do.
On colum A I enter a name (from a predfined list and the values are in another excel page) and as soon as it is selected, I want to show up in colum B the numer that correspond to that name (the values are in that other excel page next to the list of names).
hope that it is clear enough.

thx in advance
Avatar of jppinto
jppinto
Flag of Portugal image

You can use a Data Validation to select the data and a COUNTIF to perform the count of matches on the list.

Please take a look at the attached file.

jppinto
Countif-Example.xlsx
Avatar of dlan75

ASKER

it is nearly that :-) but not exaclty.
Let me try to make it clearer.

Sheet 2 column A I have names, column B I have ages
on sheet 1 if I select one of the names that is on sheet 2, I want to see the corresponding age on column B
(not so easy to explain :))
SOLUTION
Avatar of regmigrant
regmigrant
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dlan75

ASKER

Ok that's it ! Now I need to duplicate the formula to several cells without changing the namelist cells ! (I use the little cross then drag down but it changes also the namelist cell name so it doesn't work)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dlan75

ASKER

that works except when I need to duplicate the formula for the following lines
Avatar of dlan75

ASKER

ok found it :-) just needed to add a $ sign in order to fix the data. Thank you guys
That's right!