VLookup and Address

[fmm]

Does anyone know how to get the address of a cell identified by vlookup?

For example, if Vlookup(Key, Range, COl#,false) points to cell C4, I need to return C4 (or $C$4).

The vlookup range is in another spreadsheet, if that makes a difference.

 

[HaHoBe]

Hi, fmm,

I would eoither prefer Index and Match in Forumulas or use the Find-Method in VBA where the cell will be assigned to a range (and that will deliver all necessary information if a match has been found).

Ciao,
Holger