I read parts of this thread, then realized I did something different
and would like comments on this method vs. the others. If there were
comments regarding this method, I skipped over them.

For LOOKUP functions, I put everything for the operation in the sheet.
As if I was only using it in the sheet without code.
The to-look-up value is put in a cell by the VBA code. A LOOKUP
formula uses that value by reference, and the result is then read by VBA.

I figured the Excel code would be fast, therefore it would work
well, but then, I had no special speed requirement.

Does this method have any pros / cons vs. the others?