Incorporating OR into Index Match

G’day Excel forum

I’m using the index match arrangement to lookup values using multiple criteria. I’m finding an issue in that one of the criteria is the presence of one of two pieces of text, that is, the match needs to be conditional on whether the target cell contains either “text 1” or “text 2”.

I can make the range conditional on either individually, as follows;
{=INDEX(Range,MATCH("Text_1"&Criteria_2,Criteria_1_Range&Criteria_Range_2,0),Column_no.)}
… but I can’t work out how to incorporate the “text 1” OR “text 2” component.

Anyone have any thoughts?

Regards
Matt

Hi

Try testing for the existence of text 1 or text 2 in an if statement first an then add your Index / match if true. Then you can remove the reference to text 1 and text 2 from your match/index and it is simpler.

Please Login or Register  to view this content.

JimBibBowie