search a data in excel document

[MySuxs]

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?

 

[Don Guillett]

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

 

[Pete_UK]

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

Hope this helps.

Pete