Good point.

What I need is either VBA variable [or in the activecell.Offset(,1)] the actual w/s cell reference
which contains the match (previously VLookup)

Using Address(Match( ......)) I get the relative Address i.e. "A1" which is actually "J139" of w/s
1000

Tom Ogilvy wrote:

Everything you show are worksheet implementations. Not VBA.

It is unclear what you are asking.