I have a Workbook with 9 sheets all of them have tables with same design and format with different names and data, in cell "B2" there is a code for each sheet. What I need is to nest a VLOOKUP function in "C4" to search across all the sheets for a name or phone number and if there is a match to give me only the sheet code that has the matching information in Cell "B2" and I need to nest another function in the next row based on the result in "C4" to let me know the row number in the table that has that match
I have created a part of the VLOOPUP function combined with IFERROR but as you can see in the sxcreenshots below the name that I search for it is found in sheet2 "Carnel" in cell "G10" but the function in "C4" result gives me TRUE while it should give the result as "NH02" because the name is found in this sheet and also in the function I wrote if no data found to give me "No Match"
attached image 1 the sheet that has the data I'm searching for and image 2 the sheet that has to formula
I need your help please
I have created a part of the VLOOPUP function combined with IFERROR but as you can see in the sxcreenshots below the name that I search for it is found in sheet2 "Carnel" in cell "G10" but the function in "C4" result gives me TRUE while it should give the result as "NH02" because the name is found in this sheet and also in the function I wrote if no data found to give me "No Match"
attached image 1 the sheet that has the data I'm searching for and image 2 the sheet that has to formula
I need your help please