Excel – Multiple Vlookup Problem

Hi, I need to list multiple vlookup results in an orderly fashion.
Possible take me hours to research, I’m sure some one could do it in a fraction of the time.
prefer formulas and not script/VB/macros.
Thanks.