Autofill Excel search

%3CLINGO-SUB%20id%3D%22lingo-sub-2264219%22%20slang%3D%22en-US%22%3EAutofill%20Excel%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264219%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20table%20on%20a%20new%20sheet%20where%20I%20can%20search%20for%20a%20specific%20name%20which%20is%20located%20on%20column%20B.%20after%20entering%20the%20name%20I%20want%20the%20data%20in%20line%20with%20the%20name%20or%20the%20entire%20row%20to%20show%20on%20the%20table%20as%20a%20search%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20sheet%20has%20columns%20A-P%20and%20rows%201-563.%20And%20would%20like%20to%20inform%20have%20some%20Dropdown%20Content%20in%20a%20few%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20searching%20for%20the%20data%20from%20B1%2C%20B2%2C%20B3%2C%20and%20so%20on%2C%20I%20want%20the%20data%20from%20A-p%20to%20show.%20What%20can%20I%20use%20to%20achieve%20that%3F%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2264219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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 

0 Replies