<div>
I may not be understanding your request properly, but I'll give it a shot.<br><br>If you want to reference cell b3 on the second tab (named Sheet2) just use Sheet2!B3 as the reference to the cell. &nbsp;Otherwise, treat it as you would any other cell.<br><br>Is that what you are needing?
</div>


<div>
formula should end up being<br><br>Column J * Column B from Line Item Sheet where Column A Line Item Sheet = Column M from Customers
</div>


<div>
I'm not following well enough.<br>Are you able to write that formula if everything were on the same sheet?
</div>


<div>
they are not on same sheet<br><br>Sheet1 - "Customers"<br>Column J - Number of Subscriptions<br>Column M - Product (Drop Down Selection)<br>Column N - Formula I need<br><br>Sheet 2 - "Line Item"<br>Column A - Product<br>Column B - Price<br><br>Find match for Sheet1.Column M in Sheet2.Column A<br>Multiply Sheet1.Column J by Sheet2.Column B<br><br>
</div>


<div>
"they are not on same sheet "<br><br>I understand that. &nbsp;I'm trying to sort out if your issue is with how to write the basic formula or if it is an issue with looking at a different tab.<br><br>"Find match for Sheet1.Column M in Sheet2.Column A ": the VLookup function would be the useful one here to find the match and to retrieve the corresponding ColumnB.<br><br>
</div>


<div>
If you'd provide a sample spreadsheet with sample data you'd be much more likely to get a more detailed answer here.
</div>


<div>
<strong>Scenario:</strong><br>You choose items in column A (options from list on other sheet). When an item is chosen you also need a value from that list populated into the neighbouring cell, column B.<br><br>Column N of the sheet will then be column J times column B<br><br><strong>Suggestion:</strong><br>Column B can be a lookup of the item in column A
</div>


<div>
I was looking for help with the formula itself not sure of the syntax
</div>


<div>
<a href="https://filedb.experts-exchange.com/incoming/2021/08_w32/1568314/2021-August-Pricing-Strategy.xlsx" rel="ugc">2021 August Pricing Strategy.xlsx</a><br><br>Perhaps adding the test file will help<br>I need help building a formula for tab Customer column N<br>when column M in that same tab is selected a lookup to tab Line Item should look for a match in Line Item column A<br>then take the amount from the matching row column B and multiple it by tab Customers column J
</div>


2021-August-Pricing-Strategy.xlsx

SVP Product Strategy

Matt Pinkston

<div>
<div class="content wysiwyg-content fr-view">
I have an excel spreadsheet that has two tabs<br>Customers<br>Line Item<br><br>In Customers column M is a dropdown of values from column A in Line Item<br>When I select an Item from the drop down I want to multiply the corresponding column B from Line Item by Column J of the current line in Customers and the result will be where the formula was in Column N Customers&nbsp;
</div>
</div>



I have an excel spreadsheet that has two tabs
Customers
Line Item
In Customers column M is a dropdown of values from column A in Line Item
When I select an Item from the drop down I want to multiply the corresponding column B from Line Item by Column J of the current line in Customers and the result will be where the formula was in Column N Customers 

Need an excel formula that looks a multiple tabs of a workbook

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

Microsoft Excel

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.