VLOOKUP ?

  • Thread starter Thread starter bill gras
  • Start date Start date
B

bill gras

Sheet1 is my dump sheet.
For my first dump i have in column B numbers of 1-24,each
number is repeated a number of times.
In column C i have the values of column B.
the value of column C needs to go to column C in sheet2,
but i need the top 3 rows from each number in column B
with the values of column C only.
My second dump clears the first dump and enters a
different set of numbers in column B with the values in
clumn C.The numbers in column B are repeated in different
order to the first dump.
dump1 dump2 dump3 ect.
B C B C B C
1 22 1 17 1 16
1 6 1 8 3 8
1 18 1 9 3 99
1 3 2 12 3 200
2 17 2 100 3 198
2 106 2 99 7 99
2 26 2 7 7 200
2 7 2 8 7 9
2 3 4 17 7 16
2 8 4 9 7 22
3 78 5 32 7 67
I used VLOOKUP function but that gives me only the first
row of each number, I need the first 3 rows of each number
e.g:- sheet2 COLUMN C
22
6
18
Can you help?
Bill
 
Hi
try the following array formula (entered with CTRL+SHIFDT+ENTER):
=INDEX('sheet1'!$B$1:$B$100,SMALL(IF($A$1:$A$100=1,ROW($A$1:$A$100)),RO
W(1:1)))
and copy this for three rows down
 
Back
Top