How to filter a cell, dependant on 3 other cells.

Or use E2&"" to force it to text if they won't always be 3 characters long.

Originally Posted by nick.williams

Or use E2&"" to force it to text if they won't always be 3 characters long.

=INDEX(M_30,MATCH(F2,M_30[Width],0),MATCH(TEXT(E2&""),M_30[#Headers],0))
Tried this Nick, but it only caused an error. To few arguments. With it as it was, it was returning 6 characters, like 57.455 for instance.