Assuming your searching range in sheet2 is A1:O20
cell A2 in Sheet1 contains "YourText"
This formula set in A1 will return blank if not found, if found, display HYPERLINK, name "Click" and lead cursor to the relevan cell in sheet 2 that contains "YourText"
A1:
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Bookmarks