Forum Discussion
Moving large subsets of Excel data from tab to another based on criteria
Here's your sample, with the formula I had suggested in Column B. I edited it to conform to your new arrangment of the two data sets, but that was a minimal change. The formula in cell B2 reads as follows:
=IFNA(VLOOKUP(A2,C$2:D$11,2,0),"")
I copied it down the length of your data set and you can see the result. I didn't bother with the color formatting, because you can just sort based on the presence of the word "Live" in column B.
Is it possible for you to upload a sample of the file you're working with. It's awfully hard to prescribe a treatment that really is suitable without examining the patient in question. Not an image of the file; the actual file, or a subset of it. Just don't include any confidential information.
mathetes Attached is a very simple example. The first sheet/tab shows the lists I have placed side by side with the hopes of identifying exact matches. I am looking to compare column C to column A. Once the exact matches have been identified and highlighted (green in this example).............see sheet/tab 2, I will just sort column A by color and choose only the green highlighted companies (aka the EXACT matches). "Company 3" and "Company 3 Asia" would not be exact matches. Once I have them sorted, I will manually enter the word Live into the B column and now have all of my live accounts identified, and then just delete columns C and D because they will no longer needed. I'm sure there are more elegant ways of doing this, but I could not get the other equations to work. So this seemed like the simplest way. Although when I tried it, I was picking up matches that were not exact. Hope this is more clear now and I greatly appreciate your patience and assistance.
Here's your sample, with the formula I had suggested in Column B. I edited it to conform to your new arrangment of the two data sets, but that was a minimal change. The formula in cell B2 reads as follows:
=IFNA(VLOOKUP(A2,C$2:D$11,2,0),"")
I copied it down the length of your data set and you can see the result. I didn't bother with the color formatting, because you can just sort based on the presence of the word "Live" in column B.