Cell Reference of a formula Result

[dramnath1981]

I would like to know the Cell reference of the formula where the result is matching. For eg. if the Vlookup formula is matching the cell C58, I would like to know that cell reference instead of the value.

Is there any way to find out the same? Please help.

Regards, Ramnath

 

[Somendra Misra]

Hi Ramnath,

Uploading a sample file for such cases always help those who wants to help you. Also, try to give some manual outputs also. And also mention whether there will be duplicates or not in your data set?

Regards,

 

[dramnath1981]

I have uploaded the file for more clarity.

 

[Somendra Misra]

Try in G8:

=ADDRESS(MATCH(F8,$C$1:$C$10,0),3,4,1)

Regards,

 

[dramnath1981]

Great. Thank you so much Somendra.

 

[Somendra Misra]

Welcome back anytime!!

Regards,