<div>
You can specify worksheets in other workbooks from within the vlookup function. &nbsp;Look <a href="http://blog.contextures.com/archives/2010/08/23/excel-vlookup-from-another-workbook/" rel="ugc">here</a>.
</div>


You can specify worksheets in other workbooks from within the vlookup function.  Look here [http://blog.contextures.com/archives/2010/08/23/excel-vlookup-from-another-workbook/].

<div>
It's from one worksheet to another. <br />
WB1S1 - K9=+'Inventory List'!$E$14<br />
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 &nbsp;'WB1S1!$K$9<br />
thanks
</div>


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

<div>
Yes, vlookup is your answer. &nbsp;That will do the trick. &nbsp;Do you need help with the syntax?
</div>


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

<div>
Jenedge73,<br />
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.<br />
<br />
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.<br />
<br />
Brad
</div>


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

<div>
<div class="content wysiwyg-content">
I have a workbook that I've referenced an entire column of a worksheet to another workbook. &nbsp;I was wondering if there is a function that will find where the reference is coming from and reference that minus two columns?
</div>
</div>


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?

Referencing another worksheet

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.