Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Google Sheets query + minimum help needed

Dec 13, 2014 5:40PM PST

The exact file w/ the formula is here:
https://docs.google.com/spreadsheets/d/1cOMfzb-vLuggHPGzm9CSfw_ly9PRS5zcV0cg4gneBwc/edit#gid=1569548622
In the nocountries sheet.


Currently it prints each country as long as the country config is set to 'yes' in the configuration sheet.
(if you want to edit the configuration of the countries, it can be found in this doc: https://docs.google.com/spreadsheets/d/1V1sLE5H2TxNHHxaqUQDQedLZLjTh7EWbBsJO_Z0mlig/edit#gid=825633512)

I want to put a rate instead of yes in the config sheet, and so if for each product if the rate is > than what's in the config for the country, then it prints the rate, if not then it should leave that cell blank.

For example this doesn't work: =query(Full!H1:H200, "Select * where H >= '"&Configuration!B16&"' ",1)

Thanks

Discussion is locked