Copying formulas in Excel is a relatively simple operation - unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof little trick that will knock out the task for ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

It's too bad the formula checker in Excel 2000 completely blows for this sort of problem (With all those nested conditional statements).<BR><BR>edit: i think the problem is in my array paramaters ...