Jenedge73

asked on

# Referencing another worksheet

I have a workbook that I've referenced an entire column of a worksheet to another workbook. I was wondering if there is a function that will find where the reference is coming from and reference that minus two columns?

You can specify worksheets in other workbooks from within the vlookup function. Look here.

ASKER

It's from one worksheet to another.

WB1S1 - K9=+'Inventory List'!$E$14

then I want the Inventory list worksheet to find where the cell in which 'Inventory List'!$E$14 - (K9) is referenced and minus 2 rows the result should be 'WB1S1!$K$9

thanks

WB1S1 - K9=+'Inventory List'!$E$14

then I want the Inventory list worksheet to find where the cell in which 'Inventory List'!$E$14 - (K9) is referenced and minus 2 rows the result should be 'WB1S1!$K$9

thanks

Yes, vlookup is your answer. That will do the trick. Do you need help with the syntax?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Jenedge73,

Could you please post a workbook and show where the answer is required and what the answer should be. Your question says a workbook and minus two columns. One of your comments says a worksheet and minus two rows. And the example you gave looks totally unchanged.

It would also help if you posted which version of Excel you are using. Excel 2013 added a function to return cell formulas which might be useful. Otherwise, it may be necessary to use VBA code in a user-defined function.

Brad

Could you please post a workbook and show where the answer is required and what the answer should be. Your question says a workbook and minus two columns. One of your comments says a worksheet and minus two rows. And the example you gave looks totally unchanged.

It would also help if you posted which version of Excel you are using. Excel 2013 added a function to return cell formulas which might be useful. Otherwise, it may be necessary to use VBA code in a user-defined function.

Brad