Home

EXCEL FORMULA HELP

%3CLINGO-SUB%20id%3D%22lingo-sub-388992%22%20slang%3D%22en-US%22%3EEXCEL%20FORMULA%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388992%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20quote%20form%20my%20company%20uses%20and%20I%20would%20like%20to%20formulate%20two%20cells%20to%20auto%20fill%20the%20names%20I%20have%20stored%20on%20a%20separate%20workbook%2C%20or%20if%20that%20won't%20work%20I%20have%20the%20list%20on%20a%20separate%20tab%20on%20the%20same%20work%20book.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20the%20Excel%20sheet%20I%20started%2C%20I%20would%20like%20Cell%20B6%20to%20automatically%20pull%20up%20a%20name%20off%20the%20Client%20Tab%20Company%20List%2C%20i.e%20if%20I%20type%20the%20Letter%20%22D%22%20then%20all%20companies%20that%20start%20with%20that%20letter%20will%20populate.%26nbsp%3B%20Same%20goes%20for%20Cell%20B7%2C%20when%20I%20type%20the%20letter%20%22A%22%20all%20clients%20with%20the%20name%20starting%20with%20%22A%22%20will%20populate%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Micahel_P
Occasional Visitor

I have a quote form my company uses and I would like to formulate two cells to auto fill the names I have stored on a separate workbook, or if that won't work I have the list on a separate tab on the same work book.

 

Attached is the Excel sheet I started, I would like Cell B6 to automatically pull up a name off the Client Tab Company List, i.e if I type the Letter "D" then all companies that start with that letter will populate.  Same goes for Cell B7, when I type the letter "A" all clients with the name starting with "A" will populate 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies