Index formula, maybe?

[crave4excel]

Hi
I'm trying to create a formula that auto "pull in" names that are assigned to a specific group number. For example, i have a table below to start off -

type	group
orange A	2
orange b	4
orange c	2
orange d	2

<tbody>
</tbody>

I then want to create a formula that automatically pulls in the type name (2nd column) based on the group number I entered in the 1st column.

group	type
2	orange a
2	orange c
2	orange d
4	orange b

<tbody>
</tbody>

I'm not sure if this can be achieved at all, hoping the Excel gurus out there can lend me a hand! Appreciated any help in advance.

Regards,

 

[AhoyNC]

Try:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formula down as needed.

Excel Workbook
	A	B
1	type	group
2	orange A	2
3	orange b	4
4	orange c	2
5	orange d	2
6
7
8	group	type
9	2	orange A
10	2	orange c
11	2	orange d
12	4	orange b
Sheet