i have to read excel file cell value and then search it in the scroll menu and click it
but problem is that cell value and scroll menu’s name does not match 100%
for example, cell value is ‘abc’ but scroll menu name is ‘*abc’
but the thing that comes in front of abc is not always * and it varies often and it is not sure whether it is single letter or more than two letters
Therefore, i would like to find scroll menu by using partial match
how should i solve this problem?
quick response will be very much appreciated