Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #691 Aug 13, 2012 www.energyefficientbuild.com.
user Jozsef said: (http://productforums.google.com/forum/?zx=76albpq7qu02#!category-topic/docs/spreadsheets/DE-yHcVxwN0%5B1-25%5D)
Hi!
user Jozsef said: (http://productforums.google.com/forum/?zx=76albpq7qu02#!category-topic/docs/spreadsheets/DE-yHcVxwN0%5B1-25%5D)
Hi!
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,
Jozsef
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
No comments:
Post a Comment