Help with look up from one work sheet to other

[polinenileela_b]

Hi, Now I have 2 worksheets, I have took 2 worksheets as collection, so that I can search from one worksheet to other, please help me which action I can use to get perfect result, 1 collection have 25 rows 1 column (I have to search based on this 25 rows means 1 code to match the other worksheet code and get only 2 text fields ) the 2nd work sheet have 800 over rows and 7 columns, I have to take only the 2 columns data out of 7 columns .. Thanks

[John__Carter]

Potential options: 1) A loop within another loop. Easy to set up but slow to execute. Better with logging switched off. 2) Apply a filter to both collections (see Collection utility object). Slightly harder to set up but good for reducing number of rows to look through. 3) Query Excel file directly. Best way of reading from large datasheets but requires a little technical know-how. See https://blueprism.knowledgeowl.com/help/how-do-i-configure-the-oledb-vb