Trying to avoid nested IFs
First question: Does it consistently provide you with valid results?
If the answer to that is YES, then leave it alone.
I see some possibilities of reducing it to some degree MAYBE by using
SUMPRODUCT() to return values out of the Catalogo!$C$2:$F$1117 table. But
I'm not wading into this any deeper if your answer to my question was YES.
If the answer was YES, are there other issues such as taking too much time to
return a result?
"Alonso" wrote:
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??
|