inserting preceding digits (NOT USING TEXT, CONCAT, OR "CUSTOM" FORMAT) 4 VLOOKUP

Hello all I am attempting a vlookup. lookup value is a cell that contains (example) 465. the value in the table array to be found is 00000465. the only way i can get this to work is to manually add the preceding 0's with an ' (apostrophe) mark (e.g. '00000465) which populates my lookup cell with 00000465, and then the vlookup returns the value i need. I've tried adding 0's with Text Or Concatenate but get circular ref warning. Custom formatting does not work because it does not actually add the preceding )'s to the content of the cell.

I need a quick way to add the preceding zeros to the column containing the lookup value. Ideas? need more info let me know. Thanks.

Thank you Glenn, this is a great start.