Formula to extract digits and VLOOKUP help

On Sheet3 in Column C I have a list of 8 digit numbers, such as 18340134. In Column D I'd like to take just the first 2 digits of that number, copy that into a separate cell and add 6 zeros to the end of that number. In Column E I'd like to do the same thing, but this time grab the first 4 digits and then add 4 zeros to the end of it. For instance:
C D E
18340134 18000000 18340000
23090256 23000000 23090000
85110315 85000000 85110000

Once that's done, I'd like to do a VLOOKUP (I think) to Sheet4. Each of those numbers is found in column A with an description in column B (for instance, 1800000 would be "Machinery", 18340000 would be "turbines" and 18340134 would be "hydraulic turbines"). I'd like to return the descriptions in columns F, G, and H.

Thanks,
Zack

Solved.
Thank you for your quick response!