Here is a formula I'm using

=IF(B5=B4,IFERROR(HLOOKUP(VLOOKUP(B5,Referencias!$ BG$1:$BH$19,2,FALSE),Catalogo!$K$1:$Y$7,(IF(VLOOKU P(L5,Catalogo!$C$2:$F$1117,4,FALSE)<(VLOOKUP(L4,C atalogo!$C$2:$F$1117,4,FALSE)),5,(IF(L5<L4,IF(VLO OKUP(L5,Catalogo!$C$2:$F$1117,2,FALSE)(VLOOKUP(L4 ,Catalogo!$C$2:$F$1117,2,FALSE)),6,IF(VLOOKUP(L5,C atalogo!$C$2:$F$1117,2,FALSE)<(VLOOKUP(L4,Catalogo !$C$2:$F$1117,2,FALSE)),7,2)),IF(VLOOKUP(L5,Catalo go!$C$2:$F$1117,2,FALSE)(VLOOKUP(L4,Catalogo!$C$2 :$F$1117,2,FALSE)),4,IF(VLOOKUP(L5,Catalogo!$C$2:$ F$1117,2,FALSE)<(VLOOKUP(L4,Catalogo!$C$2:$F$1117, 2,FALSE)),3,0)))))),FALSE),0),0)

I know, I know
it's toooooo long

what I'm doing is comparing a machine with the last one used, then seen if
there is a swicth on the material that it needs. If true, this formula will
find how long it´s going to take finding the values in a table.

seems complicated because it search trought several tables


could anyone think on an easier way??