Hi Rock

=CELL("address",INDEX(A1:B200,MATCH(C1,A1:A200,0), 2))

where your lookup_value is in C1, the table_array is A1:B200 and the
information you want returned is in column B
(ie your vlookup statement would currently look like
=VLOOKUP(C1,A1:B200,2,0)

Cheers
JulieD


"Rock" wrote in message
...

--
Thanks

Roch