I have a formula in a Google sheet, it works great but the way I'm writing it I'll be here for years as I still need about 200 more IFs! So is there a shorter way of writing this?
=IF(A4=5191,QUERY('Calibrated Gauges'!A2:Z,"select B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R where A='5191'")...