vlookup to return the cell positioning where the criteria is found

--
Thanks

Roch

use the match function.

--
Regards,
Tom Ogilvy

"Rock" <rpage@info.ca> wrote in message
news:AEB239A0-A81D-4325-8E4B-6C342547625B@microsoft.com...
>
> --
> 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" <rpage@info.ca> wrote in message
news:AEB239A0-A81D-4325-8E4B-6C342547625B@microsoft.com...
>
> --
> Thanks
>
> Roch