Looking up multiple values and their cell locations without control F
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Help locating specific data from rangeHello all, I was wondering if someone could assisst me. Im still learning excel and having some success, but currently im struggling with a problem. I have a bunch of data across multiple cells. Some columns would have time stamps, location, error codes, vehicle numbers etc. Lets say i have a bunch of data for all vehicles and errors. How would i go about automatically filtering through the data looking for, example, error code 515. Ideally have an entire sheet that shows all data but just for a specific error code. Or a name. I appreciate any help on the matter. Even if you point me in the direction of useful information, videos etc. Id be very grateful. Thank you submitted by /u/liveactiongeek [link] [comments]
- Returning multiple matches per ID (auto-fill when dragged down?)Hi there! I have multiple assigned IDs for a single code so I need to return all matching values, not just one. I also want this to be kind of automated (?) when I drag down the upstream ID column, it can pull all corresponding values, even if they share or don't share the same code I tried using FILTER, but it only spills results in one place and doesn’t carry over properly when dragged down for other rows. I don’t want to adjust ranges every time manually since my data might get longer. Is there a way to make a formula that: works when dragged down, returns multiple matches per ID, and still updates properly even if the data goes beyond the current rows? Left Side = source workbook; Right Side = destinatioon workbook Thank you so much in advance! submitted by /u/jeankrstein [link] [comments]
- Need to return a value based on two different search criteria, multiple lines, VLOOKUPHi All, I have a report that I run at work that doesn't come out in a way that makes it easy to work with in an excel spread sheet. The best i can get it is a txt file that when pasted spreads values into different cells. I use VLOOKUP in other sheets to find one value and return another value in the same row. I don't know how to (or if it's even possible) to do this with multiple values on different rows. Could really use some help. I need some sort of VLOOKUP/XLOOKUP type of formula that does the following: -Searches Column A for a specific value -Then Searches Column B (Below where Column A value was found) for another value -Returns the value in Column C (Same Row as B) based on the value from B I'm pretty much stuck using Excel for this as my company doesn't allow outside/other programs to further organize the data. Macros may also be an option if anyone knows any. Thanks in advance with any answers. submitted by /u/QuandoOmniFluncas [link] [comments]
- Assigning one value to multiple unique IDs?I recently inherited a monster of a spreadsheet and I'm working on a project where I need to calculate billbacks down to the item level but at the moment they are calculating at the Table level. Each table can have multiple price points and billback amounts. Ex) Row 1 - Table AL3 is being sold at $35 and the charge back amount is $5 Row 2 - AL3 is being sold at $35.50 and the charge back amount is $2.50 https://preview.redd.it/g3asf16bi8qg1.png?width=350&format=png&auto=webp&s=9948ce293cbe397c4fe3e11ed3c5665b4720859d Table AL3 contains 40 unique values that I need to match with each of the 3 unique IDs above, returning 120 unique rows. Hopefully that makes sense.. I'm currently at a loss regarding how to go about this. I read that using a lookup, index and Match functions might work but I was not able to work out exactly how. Any help at all would be greatly appreciated! submitted by /u/AlmondPalmer [link] [comments]