Hey

I have a situation where I need to always make a Vlookup at the last sheet instead of the same sheet as started with, when i copy my data from one sheet to antoher.

I have tried to make an example in this file.

ExcelForum.xlsx

Kind regards