Hi @lq_c
Run lookup in a loop and change the start range as per the previous returned cell number. At the start give give the range as A1 once …and in the loop change this to the previous cell returned +1 then you will get all
Else read into datatable and then perform look up datatable in the same way
Cheers