I have a data table generated from a read range activity that kinda looks like this:
Now based on the input, I want to display values from the specific cell, like if the product is X and if the price is USD is asked then I must return 10.
How do I do this? I’m able to filter columns individually but, I’m not able to filter them by specific row. Kindly help!