2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Chillrends
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#big data management in spreadsheets
#collaborative spreadsheet tools
#real-time data collaboration
#case numbers
#unique codes
#look up
#advanced filtering
#helper column
#Excel
#A column
#D column
#feedback
#lookup method
#cell location
#multiple values
#search method