Avatar of Matt Pinkston
Matt Pinkston

asked on 

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

I have an excel spreadsheet that has two tabs
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 
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Matt Pinkston

8/22/2022 - Mon