Is it possible, using VBA, to get the FORMULA instead of the VALUE of a
cell using a VLOOKUP ?

When I do this in VBA:
result = Application.VLookup(strName, _
Names("t_Feats").RefersToRange, _
Names("index_column").RefersToRange, False)

'result' contains the value form the Vlookup - but I need the FORMULA
that has generated that value - not the value itsef !!

If it's not possible to do this with VLOOKUP, is there another way [in
VBA] to get the formula from a specific cell in the table range? The
vlookup allows me to easily locate the proper cell in the table...

strName : the NAME of the item that is searched (a la VLOOKUP, 1st
parameter)
t_Feats : Named cell representing the table I need to search
index_column : The column where the required information is located

Thanks for your help!
Richard