dlan75
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
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
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 :))
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that works except when I need to duplicate the formula for the following lines
ASKER
ok found it :-) just needed to add a $ sign in order to fix the data. Thank you guys
That's right!
Please take a look at the attached file.
jppinto
Countif-Example.xlsx