Ramadan
Board Regular
- Joined
- Jan 20, 2024
- Messages
- 136
- Office Version
- 2021
- Platform
- 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
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