I am looking for an sample code to achieve the function similar to "vlookup" in excel, but couldn't find any, was wondering if anyone could provide me with an example or direct me to an existing one? What I want to achieve is-
One the webpage, I have a "table" and a "dropdown" filter linked to the table.
when value A is selected in the dropdown, code will search in the "data collection" column "I" and pick up corresponding value B from column "II". Value B will be used as a filter for the "table".