Monday, August 13, 2012

yogi_Perform Calcs In yogi_Calc Based On Criteria in DropDowns For TYPE and LEVEL

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #691   Aug 13, 2012

user Jozsef said: (!category-topic/docs/spreadsheets/DE-yHcVxwN0%5B1-25%5D)
I'd like to thank anyone in advance for the help!
I ran into a problem regarding data extraction from two sheets with similar criterias.
I tried to search for a solution for a similar problem but didn't find anything close.
In the linked spreadsheet there are three important sheets.
'CALC sheet' the actual calculator with the three data validators with drop down selection
'DATA1' and 'DATA2' with the raw data.
In the CALC sheet there are three criterias: TYPE, LEVEL, WEIGHT.
Based on these criterias I need to extract data from DATA1 and DATA2 sheets to four columns: B;C;D;F.
I managed to apply a FILTER function for the LEVEL but couldn't figure out what to do with the other two criterias. 
Any suggestions?
Thank you,
link for the sample sheet: 
Based on my discussion with Jozsef in the Chat Window, I have presented a solution for the two criteria TYPE and LEVEL in my following blog post