Use api query method.
You can cl the matching row
If he gets matching
(also adjacent cell is empty mean use it else immediately save the value as Used in adjacent cell.)
Else alert user sorry no matching found
1 Like