Excel 2007 : How to attain ARRAY PRINTING

[APPLEBEE]

How to attain ARRAY PRINTING

--------------------------------------------------------------------------------

Hi
Gurus

I have this excel

where in i need to figure out a vlookup on set of values where i need to print the whole line that matches withthe cell value in d 22

for example if d 22 has dmy , i need a formula that looks at d8:d17 to find

DMY and bring the complete columns beside it