Simple question and more than likely a simple answer.
I have a workbook with a few worksheets, one of which is a 'data' worksheet. This information is utilized on another worksheet 'main' to fill in cell data of a few columns (using a vlookup
). On the main worksheet, another column references the vlookup
column in a formula to populate itself with information.
In the column with the formula on main sheet; by referencing the cell with the vlookup
in a formula (not the vlookup itself, but the cell/#) will the formula cell use the value from that cell or does it have to traverse the vlookup function back to the data worksheet to get the value it specifies, to be used in the formula?
Should I just specify the vlookup to 'data' as part of the formula in the formula column/cell instead of the cell reference to the OTHER column? Which method is more efficient?