Dear Excel Forum Users,

I am currently faced with the option to try do a look-up with multiple criterias. Below is the sample for index match lookup that I was working on.

=INDEX(Sheet1!D1:D10,MATCH(1,INDEX((Sheet1!B1:B10=B50)*(Sheet1!C1:C10=C50),0,1),0))

While the look-up works if the value of cell B50 and cell C50 corresponds with the column B1:B10 and C1:C10 respectively, I am hoping to add an element to "ignore" the criteria if it is blank.
In other words, if the cells B1:B10 is completely empty, the look-up should continue to work - however it will just be based on the other set of criteria in cell C50, which will do the look-up from cells C1:C10.

Currently, if I were to leave B1:B10 empty, the look-up will not work as it is unable to match any corresponding values based on cell B50.

Happy to listen to other alternatives. Many thanks in advance.

Jensen