need help in index and match here is my formula:
=INDEX(Sheet1!O16:O647,MATCH(B15,Sheet1!J16:J647,0)),INDEX(Sheet2!O16:O932,MATCH(B15,Sheet2!J16:J932)),INDEX(Sheet3!O16:O806,MATCH(B15,Sheet3!J16:J806)),INDEX(Sheet4!O16:O527,MATCH(B15,Sheet4!J16:J527))) this formula is working if not multiple criteria. hope someone can help me about this.. thank you in advance!