Forum Discussion
Return lookup value only if meeting 3 criteria based on values
I have a spreadsheet with 2 worksheets and need to transfer data from one of them to the other based on multiple conditions. The worksheets are formatted differently so I cannot just match rows and ...
You can use an index match, you need to construct it like this:
Index([result],match(1,(condition 1)*(Condition 2)*(condition 3),0))
Put the whole thing in an iferror to leave the cell blank if nothing is found.
I've attached a quick spreadsheet with it working, hopefully that gets you to what you need.