Thanks for reading this post.

I have data in sheet 1 with about 1000 Rows and 3 columns. The columns
contain the following.
- Old Account number (with leading zero) - not arranged
serially. Even if
arranged serially the increments are varied as some accounts
had been
closed.
- New account number
- Name

Similarly in sheet 2 the following fields are there
- Old Account number (with leading zero)
- Name
- Amount

I need to extract next to each Old Account Number in sheet 2 the
corresponding New Account Number from sheet 1. How can I achieve this?

Ps.
VLOOKUP in many instances returns the same New Account Number consecutively
despite a difference in the Old Account Number.