I have many rows of data held on a sheet called DataRecords. In column 'A' which holds an identifier and appears for four rows before the next group of four appears and so on.
On another sheet called Summary I need to set up a sort of lookup, which I'm struggling with (it will form a report). In cell A1 I want to enter the identifier and in cells A4:A7 a vlookup.
In cell A4 I'm currently using =VLOOKUP(A$1,ID,2,FALSE) which brings in the first record.
I realise that its finding the first row, how can I pick up the second row in cell A5?
This is my data:
This is what I'm after:
On another sheet called Summary I need to set up a sort of lookup, which I'm struggling with (it will form a report). In cell A1 I want to enter the identifier and in cells A4:A7 a vlookup.
In cell A4 I'm currently using =VLOOKUP(A$1,ID,2,FALSE) which brings in the first record.
I realise that its finding the first row, how can I pick up the second row in cell A5?
This is my data:
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ID | 01-Jan | 02-Jan | 03-Jan | 04-Jan | 05-Jan | 06-Jan | 07-Jan | ||
2 | A | 0.831194 | 0.518265 | 0.096267 | 0.645199 | 0.706429 | 0.049946 | 0.727178 | ||
3 | A | 0.730161 | 0.125968 | 0.345368 | 0.073573 | 0.771482 | 0.940802 | 0.823102 | ||
4 | A | 0.900642 | 0.420847 | 0.347148 | 0.551012 | 0.697435 | 0.722171 | 0.648806 | ||
5 | A | 0.130333 | 0.208564 | 0.514502 | 0.133617 | 0.467968 | 0.129375 | 0.804516 | ||
6 | S | 0.358189 | 0.987024 | 0.774142 | 0.057636 | 0.255244 | 0.96097 | 0.898696 | ||
7 | S | 0.301517 | 0.410683 | 0.529034 | 0.851101 | 0.877308 | 0.254552 | 0.164747 | ||
8 | S | 0.189164 | 0.994705 | 0.212221 | 0.436611 | 0.166459 | 0.00498 | 0.120284 | ||
9 | S | 0.515858 | 0.448589 | 0.80054 | 0.317056 | 0.015637 | 0.777909 | 0.050943 | ||
DataRecords |
This is what I'm after:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | A | |||||
2 | ||||||
3 | This is what I'm getting. | This is what I should get | ||||
4 | 0.831193687 | 0.831193687 | ||||
5 | 0.831193687 | 0.730161352 | ||||
6 | 0.831193687 | 0.900642452 | ||||
7 | 0.831193687 | 0.130332679 | ||||
8 | ||||||
Summary |