I want to create a table on a new sheet where I can search for a specific name which is located on column B. after entering the name I want the data in line with the name or the entire row to show on the table as a search result.
The sheet has columns A-P and rows 1-563. And would like to inform have some Dropdown Content in a few as well.
When searching for the data from B1, B2, B3, and so on, I want the data from A-p to show. What can I use to achieve that?
Thank you
