LOOKUP Return Multiple values

[SAXON10]

Hi,

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>

 

[Eric W]

Whew! Glad to help.