Hello Everyone,
I'm trying to write and index function that will return a value that meets multiple criteria. I tried to make it work based on some other internet snooping and it's just not working. It uses 2 sheets.
The function needs to return the value from Column B (sheet1) if, in the given range, column A (sheet1) = C4(sheet2) AND column C(sheet1) = D3(sheet2). This formula will be located on sheet2. The C4 value will change as the formula is applied to additional rows, but the D3 value should remain constant. I've attached a sample doc. My semi-sad efforts trying to do this on my own got me to this: but it doesn't work because I don't really know what I'm doing, hahaha:
=INDEX('Sheet1'!A3:C14,(MATCH(C4&D3,'Sheet1'!A:A&'Sheet1'!C:C,0)),2)
Any solution would be incredibly helpful. Feel free to ignore the semi-disaster of my attempt, haha. Thanks!
Bookmarks