Cell address from Vlookup

[Harry]

Is it possible when using Vlookup within VBA so that it returns the cell
address as the output rather than the cell value?

[Tom Ogilvy]

Then you would use Match

=Address(match(Target,A1:A1000,0),1)

--
Regards,
Tom Ogilvy


"Harry" <[email protected]> wrote in message
news:[email protected]...
> Is it possible when using Vlookup within VBA so that it returns the cell
> address as the output rather than the cell value?

[Philip]

Not with VLOOKUP

You have to use MATCH to return the row, MATCH to return the column, and
ADDRESS (with the results of the MATCH column and Row values) to return the
address

HTH

Philip

"Harry" wrote:

> Is it possible when using Vlookup within VBA so that it returns the cell
> address as the output rather than the cell value?