Why doesn't

=VLOOKUP(4,A1:B1000,2,False)

work?

Otherwise, try

=INDEX(B:B,MATCH(4,A:A,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"J" wrote in message
...
i have two columns. i want to look through columA for value X and want to
return the value in columnB in the same row. i need to do this without
vlookup so i can make a recursive equation that i can just drag across the
whole spreadsheat.


A B
1 6
2 5
3 7
4 8

so if i were to serch for "4" in colA, i'd get back "8"

any ideas? thanks in advance.