Forum Discussion

Amanda535's avatar
Amanda535
Copper Contributor
Jul 09, 2020

Need to calculate based on values from two separate drop down Lists

list of 16 cars, 16 brands and 16 different prices. I have a main sheet with my data, a second sheet with the table containing the drop down lists. My formula spills. I cannot for the life of me figu...
Formulas and Functions
Amanda535's avatar
Amanda535
Copper Contributor
Jul 20, 2020

mathetes just getting laptop back thanks so much for response. I've attached sheet

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 20, 2020

Amanda535 

That could be

=IFNA(INDEX('Main Sheet'!$A$4:$Q$20,
           MATCH([@[From ]],  'Main Sheet'!$A$4:$A$20,0),
           MATCH([@To],'Main Sheet'!$A$4:$Q$4,0)),0)