How Can I recall the data if I use drop down

Closed
Abdul - 2 Jun 2010 à 04:14
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 2 Jun 2010 à 05:32
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,

1 response

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