A
Alonso
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(VLOOKUP(L5,Catalogo!$C$2:$F$1117,4,FALSE)<>(VLOOKUP(L4,Catalogo!$C$2:$F$1117,4,FALSE)),5,(IF(L5<>L4,IF(VLOOKUP(L5,Catalogo!$C$2:$F$1117,2,FALSE)>(VLOOKUP(L4,Catalogo!$C$2:$F$1117,2,FALSE)),6,IF(VLOOKUP(L5,Catalogo!$C$2:$F$1117,2,FALSE)<(VLOOKUP(L4,Catalogo!$C$2:$F$1117,2,FALSE)),7,2)),IF(VLOOKUP(L5,Catalogo!$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??
=IF(B5=B4,IFERROR(HLOOKUP(VLOOKUP(B5,Referencias!$BG$1:$BH$19,2,FALSE),Catalogo!$K$1:$Y$7,(IF(VLOOKUP(L5,Catalogo!$C$2:$F$1117,4,FALSE)<>(VLOOKUP(L4,Catalogo!$C$2:$F$1117,4,FALSE)),5,(IF(L5<>L4,IF(VLOOKUP(L5,Catalogo!$C$2:$F$1117,2,FALSE)>(VLOOKUP(L4,Catalogo!$C$2:$F$1117,2,FALSE)),6,IF(VLOOKUP(L5,Catalogo!$C$2:$F$1117,2,FALSE)<(VLOOKUP(L4,Catalogo!$C$2:$F$1117,2,FALSE)),7,2)),IF(VLOOKUP(L5,Catalogo!$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??