How Can I recall the data if I use drop down

Closed
Abdul - Jun 2, 2010 at 04:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 2, 2010 at 05:32 AM
Hello,

I Have a data in a worksheet (1) which is a raw data contains ( Names, date of birth, place , Phone No.,,,etc..), on another sheet I have drop down list of these Names. My question is how can I recall the data if I choose a name form the drop down list. Say if I choose Peter on sheet 2 can the other cells automaticaly?

Thanks in advance,
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 2, 2010 at 05:32 AM
use vlookup function in sheet 2 with reference to data in sheet 1.. see help
if still any doubt post back
0