Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

It will show the value from the cell you reference. Personally, I have simply referenced a cell with the VLOOKUP in order to echo the value needed rather than add a duplicate look-up.

Keep in mind, for every VLOOKUP you have in a sheet/workbook it takes time to process. If the look-up range is small, it probably doesn't take a lot of time. But as the data range and workbook grows in complexity it may slow down.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.