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!