Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help - search formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help - search formula
On Sep 28, 9:49 am, Jamie wrote:
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. 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help - search formula
Thank you ;) I got it from there :)
"JW" wrote: On Sep 28, 9:49 am, Jamie wrote: 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. 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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help - search formula
"JW" wrote: On Sep 28, 9:49 am, Jamie wrote: 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. 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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help - search formula
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? "JW" wrote: On Sep 28, 9:49 am, Jamie wrote: 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. 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with a search formula | Excel Discussion (Misc queries) | |||
another formula search, if any | Excel Discussion (Misc queries) | |||
Search and Display Formula | Excel Discussion (Misc queries) | |||
Search formula | Excel Worksheet Functions | |||
Search within formula | Excel Worksheet Functions |