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?
Jenedge73Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
David L. HansenConnect With a Mentor Programmer AnalystCommented:
This link should help if you are getting tripped up by the syntax.  http://www.xlninja.com/2012/08/07/how-to-apply-vlookup-across-worksheets/
0
 
David L. HansenProgrammer AnalystCommented:
You can specify worksheets in other workbooks from within the vlookup function.  Look here.
0
 
Jenedge73Author Commented:
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
0
 
David L. HansenProgrammer AnalystCommented:
Yes, vlookup is your answer.  That will do the trick.  Do you need help with the syntax?
0
 
byundtCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.