I need help - search formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is what I want to do;

Type in a name and have it bring up a phone number for me. I know that it is
possible, I did it about five (5) years ago, but for the love of me I can't
remember how to do it.

If anyone can help me I would appreciate it.
 
This is what I want to do;

Type in a name and have it bring up a phone number for me. I know that it is
possible, I did it about five (5) years ago, but for the love of me I can't
remember how to do it.

If anyone can help me I would appreciate it.
Click to expand...
Is your data containing the names and phone numbers stored in another
sheet? If si, use a VLOOKUP formula. Say in Sheet2 Column A contains
the name and Column B contains the phone number. You would use the
formula below to look up the phone number for the name in A1.
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
 
Thank you ;) I got it from there :)

JW said:
Is your data containing the names and phone numbers stored in another
sheet? If si, use a VLOOKUP formula. Say in Sheet2 Column A contains
the name and Column B contains the phone number. You would use the
formula below to look up the phone number for the name in A1.
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
Click to expand...
 
JW said:
Is your data containing the names and phone numbers stored in another
sheet? If si, use a VLOOKUP formula. Say in Sheet2 Column A contains
the name and Column B contains the phone number. You would use the
formula below to look up the phone number for the name in A1.
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
Click to expand...
 
Okay I am just button happy today.

My next question are these;
Is there a way to make the VLookup less stringent on "vector"? For instance,
I want to find the number for Gyuran, but I don't know how to spell it so I
want to type in Gy.

The other one is this;
Is there a way for it to list all the results?
 
Back
Top