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

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic