vlookup to return the cell positioning where the criteria is found

--
Thanks

Roch

use the match function.

--
Regards,
Tom Ogilvy

"Rock" <[email protected]> wrote in message
news:[email protected]...
>
> --
> Thanks
>
> Roch

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" <[email protected]> wrote in message
news:[email protected]...
>
> --
> Thanks
>
> Roch