I am trying to pull data from a different sheet in google sheets by matching row and column header EG
LOC prox dist qty sjc 12 15 19 dfw 10 16 8 atl ord
In sheet a, I am trying to ref dynamically in sheet b something like:
cell g1 = "Prox" cell a3 = "SJC"
in cell g3 the formula should be the equivalent of
"select g3 where col1=a3" and return the value "12"
I haven't found any code that seems to work. I have tried to use query function but it doesn't like dynamic or strings.
Edit: Created an example sheet Summary and Source data https://docs.google.com/spreadsheets/d/1NkCAMrymdPcN29oi_DpHtKbYh7w9tPODzBqU_aCmtnk/edit?usp=sharing