First off, I’m a total noob.
I’m trying to create a document that looks up (and displays) a shipping cost (from a table) based on values that the user enters. I would have thought that this would be fairly simple, but I haven’t been able to find anything that helps me get to that point.
I have a table, with shipping zones in columns, and weight in rows. I want to input, for example, 8 for the weight, and Europe for the zone, and have the doc look up from the table that the charge for 8kg to Europe is $50.
I suspect I should be able to use filter or lookup, but can’t get my head around how to implement it.
Any help would be much appreciated.