Hello Friends ,

I am extensive user of yahoo messenger and talk to people with
different
profiles, but my problem is I tend to forget chatter's details.
Therefore I've prepared a spreadsheet containing various details of
my chat friends.


Database is on "Sheet2"

And I wish to search my friends profiles by "unique nick name" which I
give them. Can anyone give me fuction/forumlas

To search frds by their nick in "Sheet1"


I am attaching my sample file for the same.


+-------------------------------------------------------------------+
|Filename: pramod.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5149 |
+-------------------------------------------------------------------+

--
mumbai_ranger
------------------------------------------------------------------------
mumbai_ranger's Profile: http://www.excelforum.com/member.php...o&userid=17387
View this thread: http://www.excelforum.com/showthread...hreadid=568588

use Vlookup function
I have attached implemented file

mumbai_ranger Wrote:
Hello Friends ,

I am extensive user of yahoo messenger and talk to people with
different
profiles, but my problem is I tend to forget chatter's details.
Therefore I've prepared a spreadsheet containing various details of
my chat friends.


Database is on "Sheet2"

And I wish to search my friends profiles by "unique nick name" which I
give them. Can anyone give me fuction/forumlas

To search frds by their nick in "Sheet1"


I am attaching my sample file for the same.


+-------------------------------------------------------------------+
|Filename: pramod-1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5150 |
+-------------------------------------------------------------------+

--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=568588