Hi,
How to return the multiple values using lookup and removing duplicates corresponding to the
ranges.
Any help much appreciated
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
How to return the multiple values using lookup and removing duplicates corresponding to the
ranges.
Any help much appreciated
DATA | OUTPUT | |||
Category | Item | Category | ITEM | |
1 | D | 1 | A | |
2 | A | B | ||
1 | A | D | ||
1 | A | 2 | C | |
1 | B | 3 | E | |
1 | B | 4 | AAA | |
1 | D | 5 | C | |
2 | C | D | ||
3 | E | E | ||
3 | E | |||
3 | E | |||
4 | AAA | |||
5 | E | |||
5 | C | |||
5 | D |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>