Hey All:
I've got a big workbook and I have simplified my issue with example data below.
Is it possible to have 2 horizontal lookups and a vertical? Here is a snippet of hypothetical data and results. I've used nested index match before, but I can't get it to work here.
Can you write this so that Data is on Sheet1 and Output is on Sheet2? The data will have blank rows and columns periodically, so the formula has to be hearty.
Thanks in advance!
I've got a big workbook and I have simplified my issue with example data below.
Is it possible to have 2 horizontal lookups and a vertical? Here is a snippet of hypothetical data and results. I've used nested index match before, but I can't get it to work here.
Can you write this so that Data is on Sheet1 and Output is on Sheet2? The data will have blank rows and columns periodically, so the formula has to be hearty.
Thanks in advance!