exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi There,
I have a data like this in both sheet.
i Want to put a lookup for 2005 in second sheet and get 1;2;3;4;5;6 in column B in sheet 1. How do i do that?
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>
I have a data like this in both sheet.
i Want to put a lookup for 2005 in second sheet and get 1;2;3;4;5;6 in column B in sheet 1. How do i do that?
Sheet 1 | Sheet 2 | ||||
COLUMN A | COLUMN B | COLUMN N | COLUMN AX | ||
2005 | 1;2;3;4;5;6 | 2005 | 1 | ||
2005 | 2 | ||||
2005 | 3 | ||||
2005 | 4 | ||||
2005 | 5 | ||||
2005 | 6 | ||||
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>