RINCONPAUL

07-16-2017, 11:57 PM

I have an index match array formula:

{=IFERROR(INDEX(BD$2:BD$902,MATCH(AV$2&AW$2&AV5,BA$2:BA$902&BB$2:BB$902&BC$2:BC$902,0)),"")}

At this point it's a 3 way lookup. I want to introduce a 4th column to lookup (BE$2:BE$902). However rather than each cell being filled with a static value, I want to introduce a different ">=" or "<=" a numeric value in each column cell. Example BE$2 is >=2.0, BE$3 is <=3.4,.....

I know I could do it by introducing a horizontal index of values but there would be 100's. Any ideas welcome.

{=IFERROR(INDEX(BD$2:BD$902,MATCH(AV$2&AW$2&AV5,BA$2:BA$902&BB$2:BB$902&BC$2:BC$902,0)),"")}

At this point it's a 3 way lookup. I want to introduce a 4th column to lookup (BE$2:BE$902). However rather than each cell being filled with a static value, I want to introduce a different ">=" or "<=" a numeric value in each column cell. Example BE$2 is >=2.0, BE$3 is <=3.4,.....

I know I could do it by introducing a horizontal index of values but there would be 100's. Any ideas welcome.