search a data in excel document
 

Need help to search excel document. For example I have a excel document with
my Contacts - name, phone, email and address. I receive a call in my cell and
couldn't take it and goes to miscall. That number is not already saved in my
cell. I need to know who is this, just in case, in my Contacts.

Is it possible by using a phone number to findout the other details?

search a data in excel document
 

You can do this several ways:
a FIND macro
match/index formula


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MySuxs" wrote in message
...
Need help to search excel document. For example I have a excel document
with
my Contacts - name, phone, email and address. I receive a call in my cell
and
couldn't take it and goes to miscall. That number is not already saved in
my
cell. I need to know who is this, just in case, in my Contacts.

Is it possible by using a phone number to findout the other details?

search a data in excel document
 

You could set up autofilters on each column and use the drop-down to
select phone number (or name, etc)

Hope this helps.

Pete

On Aug 18, 8:49 pm, "Don Guillett" wrote:
You can do this several ways:
a FIND macro
match/index formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"MySuxs" wrote in message

...



Need help to search excel document. For example I have a excel document
with
my Contacts - name, phone, email and address. I receive a call in my cell
and
couldn't take it and goes to miscall. That number is not already saved in
my
cell. I need to know who is this, just in case, in my Contacts.

Is it possible by using a phone number to findout the other details?- Hide quoted text -

- Show quoted text -