I have a Google Sheet and I want to look up a row in the Sheet by querying 2 columns.
For example, I want to find a row by looking up column A and column B simultaneously. I don’t think this can be done but I could conceive of a work around.
Any thoughts out there in the community?
thanks
gml