Sort and display by catagory using formulas (ignore zeros)

Good Afternoon Excel Guru's

I apparently ran into a brick wall and it hurt . So my problem is I cannot figure out a way to have a vlookup look at a cell, then if it is blank move to the next cell. That being said, I am also trying to not leave gaps if the cell is 0(zero).

Please help. I have attached an example file. Thanks.