FORMULAS W/FUCTIONS

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

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
 
I found a solution... but I have one question... I don't want to print
some cells... how can I do it?
 
I found a solution... but I have one question... I don't want to print
some cells... how can I do it?
Click to expand...

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