I'm trying to sort information that has been generated using the Vlookup Formula. Unfortunately there is no "master worksheet" to presort all the names because of the number of exteral sources we receive information from.
Does anyone know of a way to sort this information? It's not possible to create a lookup table due to the number of names that are in it, 2-3 thousand names.
Since so many people would have access to this workbook, I'm trying to keep the final worksheet in a usable format for all. I've included some sample data below.
Col's F-J would be generated from the other worksheets using vlookup. If everything checks out, then Col K will produce a "Y", otherwise, "N". If Col K produces a "Y", then Col A & B will pull the #'s and complete name.
Col D, then needs to alphabetize the information from Col B.
Any help would be greatly appreciated.
Does anyone know of a way to sort this information? It's not possible to create a lookup table due to the number of names that are in it, 2-3 thousand names.
Since so many people would have access to this workbook, I'm trying to keep the final worksheet in a usable format for all. I've included some sample data below.
Col's F-J would be generated from the other worksheets using vlookup. If everything checks out, then Col K will produce a "Y", otherwise, "N". If Col K produces a "Y", then Col A & B will pull the #'s and complete name.
Col D, then needs to alphabetize the information from Col B.
Any help would be greatly appreciated.
Last edited: