Solved: reverse lookup

[CCkfm2000]

help...

i have some data and what i need is to reverse lookup.
is it possible to do?

eg :- lookup 2 will bring up "32" & "name d"

a1 = name a
a2 = name d
a3 = name c
a4 = name b

b1 = 26
b2 = 32
b3 = 27
b4 = 50

c1 = 1
c2 = 2
c3 = 3
c4 = 4

many thanks

[Bob Phillips]

=INDEX(A:A,MATCH(2,C:C,0))

etc.

[CCkfm2000]

just worked out the first bit to the problem.

cell e1 = 2
cell f1 = "=INDEX(A1:A4,MATCH(E1,C1:C4,0))"
cell g1 = "=INDEX(B1:B4,MATCH(E1,C1:C4,0))"

what i need now is to get all the data with 2 in them, one after another.

a1 = name a
a2 = name d
a3 = name c
a4 = name b

b1 = 26
b2 = 32
b3 = 27
b4 = 50

c1 = 1
c2 = 2
c3 = 2
c4 = 4

thanks

[Zack Barresse]

Select headers | Data | Filter | Autofilter

[CCkfm2000]

just done that late last night.

got it working...

thanks for all the help....