W
WTG
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
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