FORMULAS W/FUCTIONS

[Fernando Duran]

I have a sheet with rates, I use this formuila to pick the rates

=INDEX($C$3:$C$5000,MATCH(F2,IF($B$3:$B$500=F3,$A$3:$A$500),0))

this is one time deal, but the way it supposse to work, is by passing
many time as need, if we have 3 ctns, 3 times, the formula has to run,
base in the in the weight.. Tell how can I do it without going into
macros..

Fernando

 

[Fernando Duran]

I found a solution... but I have one question... I don't want to print
some cells... how can I do it?

 

[Dave R.]

Select the area you do want and when you print, select "print selection"..

 

[Jonathan Rynd]

I found a solution... but I have one question... I don't want to print
some cells... how can I do it?

Designate an entire row or column for the temporary cells, and then hide
the column or row.