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