Share via

Searching for a name using a phone number.

Anonymous
2023-07-31T21:22:00+00:00

Hello! I'm looking for a way to make a rule where I can have a search engine at the top of my excel sheet. Essentially, I want to search someones phone number and in a separate cell I want it to say their name. Can anyone help me with this? It would be greatly appreciated! Thanks!

Windows for home | Windows 11 | Performance and system failures

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. EmilyS726 227K Reputation points Independent Advisor
    2023-08-01T21:26:54+00:00

    You are welcome. Yes, I would appreciate a bit clarification. Are you saying the data lives on a different sheet compared to where the fomula is?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-08-01T21:24:14+00:00

    Hi Emily, thank you so much for your help. I didn't realize that the phone numbers are being copied over from another sheet. Is there a way to have it read the formula/the copied version? Does this make sense? I can also provide screenshots if needed. I appreciate your assistance.

    1 person found this answer helpful.
    0 comments
  3. EmilyS726 227K Reputation points Independent Advisor
    2023-08-01T17:57:24+00:00

    Got it.. If you want to have it take you to where the participant ID is located, you will need to write VBA code for that. For that, It is exceeding the supporting scope of this forum and you will need to visit the Q&A forum instead.
    https://learn.microsoft.com/en-us/answers/

    But as a simpler solution to achieve the result, the following formula can return the cell location.

    So in this fomula, Column A is the participant ID, and Column B is their numbers. Then I am setting up Cell F1 as the input area for user to enter phone number. Based on the value in Cell F1, it will then return the cell location info by using the following formula. I will include a screenshot as well so you can see the set up. In my screenshot, cell location output is in F3.

    =ADDRESS(MATCH(F1,B:B,0),1,4)&":"&ADDRESS(MATCH(F1,B:B,0),1,1)

    Image

    0 comments
  4. Anonymous
    2023-08-01T17:40:17+00:00

    Hi Emily, This is what it looks like. I want to type in a phone number somewhere, and then it takes me to where the participant ID is located. Thank you and I appreciate your help with this!

    0 comments
  5. EmilyS726 227K Reputation points Independent Advisor
    2023-07-31T21:57:19+00:00

    Hello Christopher, this is Emily.

    I am afraid you will need to provide a lot more details in this question. The answer depends heavily on what the data looks like. Do you have the raw data in Excel already? If so, can you share a screenshot? I am imaging you have a column that are names, and another column next to it with phone numbers? If that's the case, you can use the Vlookup formular in Excel to do this. But I would love to see how the data is like in order to include the entire formular, so I can reference cells, etc.

    0 comments