I have 2 tables on separate tabs that I would like to search for any row containing a criteria and return the whole row.
After converting the data to tables I create a new tab just for my search and am using cell B3 as my search criteria text box.
I am using the following formula and no matter...