I'm looking for anything that says "yes" in column 21, and I need to return values in other columns based on multiple criteria. Trust me, I would much rather use a formula (like a vlookup or an INDEX), but i think VBA would work smoother.