PDA

View Full Version : Solved: reverse lookup



CCkfm2000
10-26-2005, 06:27 AM
help...

i have some data and what i need is to reverse lookup. :think:
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
10-26-2005, 06:59 AM
=INDEX(A:A,MATCH(2,C:C,0))

etc.

CCkfm2000
10-26-2005, 07:06 AM
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
10-26-2005, 10:58 AM
Select headers | Data | Filter | Autofilter

CCkfm2000
10-26-2005, 11:12 PM
just done that late last night.

got it working...

thanks for all the help....