Excel 2007 : How to attain ARRAY PRINTING

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

Try:

=VLOOKUP($D22,$D$8:$O$17,COLUMNS($A$1:B$1),FALSE)

copied down and across

or

=INDEX(E$8:E$17,MATCH($D22,$D$8:$D$17,0))

copied down and across