how do I use vlookup to get more then one line?

everything I try calls up the same line of information...

ie....

I would like to use the value of C8, and pull out all the rows above
it that have the same value in column A, and copy them to rows
11,12,13,14...


A B C D
1 WHO 123 456 789
2 WHY ABC DEF GHI
3 WHO 101 112 131
4 WHEN 123 321 321
5 WHERE 454 HGH
6 WHO OIUI IOOI OIJ
7
8 WHO
9
10
11 WHO 123 456 789
12 WHO 101 112 131
13 WHO OIUI IOOI OIJ
14


thanks for the help

Wally