Lookup Formula to find correct value & update

Hello, I have an ID in Column I - this ID will partially match the ID in another file.

What I would like to do is a find the full ID (using the partial ID) from the other sheet, and update all of the same partial IDs in my original file to the full ID.

I tried VLOOKUP with True, however that did not bring in the correct corresponding ID.

All IDs start with the same 5 digits, the following 5 digits are unique (like a UPC Code)

What I am doing now is looking for the Partial ID in my second file, copying that - then doing a find and replace on my original file to update all the IDs.

Any help would be greatly appreciated.

Difficult to visualize your setup.
Take a typical vlookup
=VLOOKUP(A1,'OtherSheet'!B:C,2,FALSE)

Which dataset has only 5 digits, A1, or Column B on OtherSheet ?

Can you work up a sample workbook and attach it?