Vlookup and write range

Hi there everyone, i need help on this. I am trying to do a vlookup from file(1), then return and write range to file(2). any advice on this?
for example, if i lookup “Banana”, i want to write the whole row of data to file(2).

thanks in advance for your help!

Hi @j0c314n please find the attached workflow.Hope this fits you requirement
Main.xaml (9.4 KB)

hi @j0c314n , please find attached workflow

VlookupQuery.xaml (13.3 KB)