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.
You'd need to describe the situation a bit more...but that formula takes the place of whatever is there (that's just the nature of it).
So if you have some other status descriptions that you also want to recognize, maybe we need to make this more complex, like having a table with various descriptors of criteria for determining what status ("Live" being only one of the possibilities).....
mathetes Essentially I have a list of customers that have gone live. Your formula has beautifully inserted them. However, within my customer list I also have existing statuses such as 'new' or a 'target go live date' that the formula overwrites with a blank. It sounds like there is no easy fix, so I can just past the formula around the existing statuses. Thanks again.