Trying to VLookup Skus starting with 0

Hi all,

I have a couple of sheets that I'm trying to consolidate into one by doing a vlookup using the skus as a key.

The issue that I'm having is that in some of my sheets that contain the SKU it cuts off the 0s at the start.

I'm aware this is because it's a number etc but I've tried to format it to text and it's not working. The other issue is that while they're all skus they can vary. For example, one SKU might be 123, another might be 000123, and another might be 00000123123123 or even abcdefg. Point being is that the length and etc can vary (also working with thousands of different skus).

How do I make it so that regardless of length, some skus starting with one 0, multiple zeros, or no zeros at all in one column etc that I can still vlookup via SKU?

Thank you!