Looking up multiple values and their cell locations without control F
Hello everyone I am currently working with case numbers that look like the following
05265101
05263313
05263327
Each of these numbers are unique and are also in the A column
In the D column there's a header called feedback and in each of the rows associated with the same case numbers as above there goes a text that corresponds to the unique number.
What method can I use to look up each of these numbers in the corresponding cell value at the same time without using advanced filtering. The reason why I can't use advanced filtering is because I am working in a collaborative environment and sheetview does not work with advanced filtering.
The reason why I am asking this is because at certain times the numbers above can reach upwards of a 100+ unique codes that all correlate to one specific name, and I have to manually search all of those codes and allocate the corresponding name.
Thank you in advance!
Some restrictions that exist is that I can't add a helper column directly next to the other columns because management does not allow this. However any and all extra excel files are good to go.
[link] [comments]
Want to read more?
Check out the full article on the original site