Search for a Name or Phone number among multiple sheets

Ramadan

Board Regular
Joined
Jan 20, 2024
Messages
136
Office Version
  1. 2021
Platform
  1. Windows
I have a workbook with 9 sheets subject to be increased in the future, All the sheets have the same table design, format and the same starting row number
in cell "B2" in each sheet there is a code as a name for the contents like "NH01,NH02,NH03, etc...

What I need is to be make a formula or something in any sheet of them that make me able to search in theses sheets for any name or phone number (inserted as text) between columns ("D:M") and if there is a match to let me know the sheet code in "B2" to know the sheet name that has the match and the row number in the table or even the row number in the excel sheet
for your kind information there might be more than one result - is that possible ?

Thank you in advance for your help
 
It is possible. But, in order to give any type of assistance it will be necessary to know where the Name and Phone Number are located. ie. The column (field) name. Additioanly, maybe 8-10 rows of sample data to understand what your sheets look like. Please use XL2BB for your example.
 
Upvote 0
It is possible. But, in order to give any type of assistance it will be necessary to know where the Name and Phone Number are located. ie. The column (field) name. Additioanly, maybe 8-10 rows of sample data to understand what your sheets look like. Please use XL2BB for your example.
@alansidman
Untitled.png
Thank you Screenshot Attached
 
Upvote 0
Firstly, I cannot manipulate data in a picture. XL2BB allows us to work your data without having to create a spreadsheet and reenter the data.
Secondly, if I were to do this, i would restructure the range/table so that it was normalized. With normalized data you can do analysis without having complex issues. If you don't know about normalized tables then read the following.


Once your data is normalized then you can do lookups with ease. To get your current data normalized, you can use Power Query to unpivot the data and then you can do your lookups easily.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,926
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top