Please find the example below for more understanding.
This is the table I have after i searched the from the website
My question is, how can I get the “3000 000003” if the item No = “0804027” (this number is come from excel, so that I can read this number from excel and “search” from this table) and store “3000 000003” into excel sheet. I’m able to get all the data from this table by using data scraping but i’m not sure what to do to get the single item in the table. Is anyone know what to do?
This is the excel I have
This is the result I want to see
Appreciate someone can help on this issue. Thanks.