Good afternoon guys,
I have just been introduced to this forum, and couldn´t wait to post my first thread (yey...)

I am not experienced with excel, therefore please take me slow...
I am trying to create a ¨calculator¨ that would be able to analyze a pretty big table, then provide the most efficient cost out of that table, taking into consideration the origin and destination of the freight. For example:
**NOTE THAT IT IS SET UP IN SPANISH, SO THE FUNCTIONS SOUND A LITTLE FUNNY.

=SI(Y($AB$5=D4;$E$103<=$E$3);E4;SI(Y($AB$5=D4;$E$103<=$F$3);F4;SI(Y($AB$5=D4;$E$103<=$G$3);G4;SI(Y($AB$5=D4;$E$103<=$H$3);H4;SI(Y($AB$5=D4;$E$103<=$I$3);I4;SI(Y($AB$5=D4;$E$103<=$J$3);J4;SI(Y($AB$5=D4;$E$103<=$K$3);K4;SI(Y($AB$5=D4;$E$103<=$L$3);L4;SI(Y($AB$5=D4;$E$103<=$M$3);M4;SI(Y($AB$5=D4;$E$103<=$N$3);N4;SI(Y($AB$5=D4;$E$103<=$O$3);O4;SI(Y($AB$5=D4;$E$103<=$P$3);P4;SI(Y($AB$5=D4;$E$103<=$Q$3);Q4;SI(Y($AB$5=D4;$E$103<=$R$3);R4;SI(Y($AB$5=D4;$E$103<=$S$3);S4;SI(Y($AB$5=D4;$E$103<=$T$3);T4;SI(Y($AB$5=D4;$E$103<=$U$3);U4;SI(Y($AB$5=D4;$E$103<=$V$3);V4;SI(Y($AB$5=D4;$E$103<=$W$3);W4;¨¨)))))))))))))))))))

So this is the formula for the first row. If the Name in AB5(calc) = the name in D4(actual table), then it needs to see what range the Kilos are falling in, being no less than 19 categories. If the weight is <= to 250, 500, 750...
Now, each row requires more or less the same formula, so it can look for the criteria in AB5 all over the table... As you probably already know, it doesn t allow me to se more than 64 levels of nesting, reason for which I have posted this thread...
Could anyone help?
Thank you all for your time and assistance, looking forward to hearing from you