the cells wont auto resize with out some vba code, if you go down that path you might as well have the whole thing done that way, it would probably be much better.
now you could just wait and hope someone posts or start a new entry in the programming forum called something like "convert vlookup to vba and auto resize cells to fit results"
linking to this thread