I'm trying to adapt a spreadsheet set-up by someone else for my own use. They
use VLOOKUP and HLOOKUP throughout the doc. The cells pull off of other tabs
in the worksheet. I would rather use the SUM function and click on the cells
I want from other tabs. Would that be just as effective? If not, why is
VLOOKUP better to use? We are using it to calculate company turnover numbers.