Excel Searchable Lists

%3CLINGO-SUB%20id%3D%22lingo-sub-737982%22%20slang%3D%22en-US%22%3EExcel%20Searchable%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737982%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20commemorate%20American%20Independence%20Day%2C%20I%20hereby%20share%20my%20Excel%20file%20with%20searchable%20lists%20of%20the%20popular%20American%20Names%20for%20those%20born%20from%201919%20to%202018.%20Delve%20into%20it%20and%20please%20apprise%20me%20of%20your%20thoughts%20thereon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-737982%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%3CLINGO-SUB%20id%3D%22lingo-sub-1610041%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Searchable%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20reply%20-%20had%20a%20quick%20look%20at%20the%20file%20and%20it%20works%20well%20enough%20for%20what%20you've%20built%20-%20I'll%20have%20a%20look%20at%20the%20formula%20in%20detail%20but%20it%20doesn't%20completely%20answer%20the%20question%20I%20had%20-%20happily%20a%20little%20more%20Googling%20has%20led%20me%20to%20the%20answer%20-%20I%20need%20to%20transpose%20the%20searchable%20list%20results%20horizontally%20and%20then%20use%20that%20result%20in%20each%20row%20I%20wanted%20it%20for%20(again%20thanks%20to%20the%20xelplus%20site%20for%20the%20answer!!)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Trusted Contributor

To commemorate American Independence Day, I hereby share my Excel file with searchable lists of the popular American Names for those born from 1919 to 2018. Delve into it and please apprise me of your thoughts thereon.

1 Reply

@Twifoo thanks for the reply - had a quick look at the file and it works well enough for what you've built - I'll have a look at the formula in detail but it doesn't completely answer the question I had - happily a little more Googling has led me to the answer - I need to transpose the searchable list results horizontally and then use that result in each row I wanted it for (again thanks to the xelplus site for the answer!!)