Reply
F75 Frequent Visitor
Frequent Visitor
Posts: 12
Registered: ‎11-27-2016

CALCULATETABLE VALUES with more than one filter

[ Edited ]

I have two tables 'Data' and 'Input'. I am tryng to lookup value for Account and Scenario in 'Data' table from 'Input' tables. In 'Input' table scenario is arranged in columns. How can i use a lookup function to retrive data based on row values from table 'Data'?

 

e..g Row 5 

 

2017 Plan A |  Sales | .........| 1010 (New Unit Price)

Data

data.JPG

 

Input

 

Input.JPG