Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

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?
0
Jenedge73
Asked:
Jenedge73
  • 3
1 Solution
 
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
 
David L. HansenProgrammer 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
 
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

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now