I am looking for a Vlookup macro between two sheets. But every time the rows in sheet 2 will differ. So looking for a vlookup with dynamic range...

Regards,
Vijay