For example, say my sheet is like this:
with the 4th column containing desired outputs.
If I wanted to do a match where it first checked if Column A was the same, then looked at if there were any trues in column B, and returned the value in column D whenever a True was found in column C, would it be possible?
It would look like this:
I believe I'd have to use an array formula, but would prefer if there was a solution not requiring one, as the worksheet constantly changes.
I've gotten the formula to almost work, but I am having a hard time coming up with a logical statement to divide column A into "sections." Any help in that area would be greatly appreciated. I'm basically trying to use a combination of if statements and index(match(), since those are about all I am familiar with. Maybe someone knows of a more elegant solution. So far, the closest thing I've come up with is utilizing the exact function to divide the A Column, but that only works for the first division, and returns all false for everything else.
Sorry for the bad formatting, tried to illustrate my question as best as possible...
Thanks in advance for any help.
Bookmarks