How can I optimize a nested multiple criteria lookup-boolean function?

[George_Martin_3]

This function returns a true or false statement if the corresponding lookup value is less that the table settings.
The lookup-table is static but the lookup-values are dynamic and may exist in the lookup-table in more than way. We have built the function logic to answer the question 'does this statement exist in the table' at the highest level of resolution first. How can we improve this function? Thank you!

=IFERROR(BE2<VLOOKUP(I2&O2&P2&AU2,'Y5 Table'!A:Q,17,0),IFERROR(BE2<VLOOKUP(I2&O2&P2&CA2&CB2&"*",'Y5 Table'!B:Q,16,0),IFERROR(BE2<VLOOKUP(I2&O2&P2&CA2&"*",'Y5 Table'!B:Q,16,0),IFERROR(BE2<VLOOKUP(I2&O2&AU2,'Y5 Table'!C:Q,15,0),IFERROR(BE2<VLOOKUP(I2&O2&CA2&CB2&"*",'Y5 Table'!D:Q,14,0),IFERROR(BE2<VLOOKUP(I2&O2&CA2&"*",'Y5 Table'!D:Q,14,0),IFERROR(BE2<VLOOKUP(I2&AU2,'Y5 Table'!E:Q,13,0),IFERROR(BE2<VLOOKUP(I2&O2&CA2&CB2&CC2&"*",'Y5 Table'!D:Q,14),"Lookup Error"))))))))

 

[Gerald Higgins]

Tell us what you mean by "improve".

Does this formula work for you ?

If not, what is it doing wrong ?

If yes, in what way do you want to improve it ?