Search Correct No in SAP

[AsitabhaDeb]

​​HI Experts,

In my process There are 5 component no in SAP.
Out of that 5no, 1 component no is in another excel file. (Source Excel File)
My requirement is BOT will match the correct component no from SAP and Source excel and after find the correct component no BOT will double click on the line no.

I hope I make you understand.
Attachment for ref.
I need to click on line# 2 because that component is matching with my source excel file.
For next material# line# can be change.

NEED TO CLICK ON LINE# NOT IN COMPONENT#.

BR/Deb

[expertcr]

I think your problem is to click one of the elements in that table?
Without thinking in Excel, can you click with no problems in these elements in SAP?

[remko.bouwens]

When working in SAP, you can use three ways (I can think of) to find it.
1. Setting a filter, using the component no as filter. This should leave one result (you check this by reading the cell value of the first row).
2. Using the FIND (Ctrl+F or the binocular button) menu and search for the component no. After searching it should highlight/select your component no.
3. Loop through the list until you find the correct value (if you are able to spy all cells(.