Searching for mulitple criterea in an unstructered cell
Our take
Hello people,
english isn't my first language so I apologize in advance if my description of the issue isn't the best or I don't use the proper terminology.
Here is what I'm hoping to achieve. I'm trying to match entries based on partial contents of the cells with mulitple criterea. For example in the picture in column F ' Text'. There are mulitple different things contained in it, in no set order. But every entry in column F contains either the reference in column A oder the casenumber in column B, or sometimes both. For the data in columns A, B and C I can say that the row is always matched, so a row always belongs together. I have been trying to give out the name in column C into column F with VLookup, so that Smith would show up in F2, Park F3, Smith F4, Smith F5, and Miller F6
I have been unsuccesful so far trying to use partial matches or filter for character lenght, but nothing I could find seems to be suitable for this situation. I have googled a lot and watched a few dozen videos but didn't find a solution, but maybe I have not been looking for the right things.
I hope someone can help me with a formula or method this can be achieved.
Thanks in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Looking up multiple values and their cell locations without control FHello 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]
- Search for value in column and compare values to show if they match don't matchStuck in excel hell for the last while with this heres my problem: Trying to check if my value in column c is a match to a value located somehwere in column h where colums a and f would contain the reference parts top match them, should i be moving the values from colums f out ward to a different sheet maybe? using the formula below is spitting out an error.....if anyone can help i'd really appreciate it =IF(LOWER(TRIM(C2)) = LOWER(TRIM(XLOOKUP(A2, F:F, H:H))), "Match", "Mismatch") if anyone has any ideas of would know how to do this if moving information from colums f onwards out then please let me know how to do it as I'm at my wits end with this. submitted by /u/RestScary6702 [link] [comments]
- Multi criteria Xlookup efficiency problemI'm using an Xlookup with multiple criteria. For now I'm using: Xlookup (A1&B1, E:E&F:F, G:G) This is slowing the file down since I'm using variations of this formula in multiple columns (with 4 or 5 criteria in some columns) and I have ~ 150k rows or so. Any way to make this more efficient? submitted by /u/procrastinator__101 [link] [comments]