Vlookup cell link with other other sheet,how can i trace the cell linked from

excel 2010 , linked the 2 sheet with Vlookup, , looking for help if there is some solution,

sheet one is cost sheet, sheet 2 is one we are linking by Vlookup ,

if I click on sheet 2 cell row 16 is there any way that cell show where this cost was linked from sheet 1 cost

because on cost sheet we have more than thousands rows its takes long time to search for that model for that model , when we want to identify where this cost linked from, because my boss wants to see the more details

can some one please help this, how can we trace it faster , just clicking on that one cell , that can take us back on original sheet on that model cell.

hope mu question is not confusing, I have attached the file also.

I did looked at the trace Precedents, that's not what we are looking for,

any help will be appreciated

you can use the match() to find the row of where that came from

=MATCH(C16,cost!C:C,0)

thanks for quick reply, I tried this formula , getting error message, don't know what I am doing wrong.
can you please show in the attached file and on the cell,

and other thing, I model # match with the cost also,

when I click on cell for example cell C16

it can show the cost sheet tab model # and cost both field

really appreciate all the help

=ADDRESS(MATCH($C7,cost!$C$1:$C$30,0);;;"sheet1")



I tried this below formula , and attached file on column E7 had the same formula added, it does not do anything , when I click on sheet 2 cell C16 , it should take me on tab Cost cell B22 model 100A115, its not doing that . what I am doing wrong, can you please advise,



I tried the other formula also

=MATCH(C16,cost!C:C,0) this formula give me row # what row for example 6, 12, on cost tab that model, but still does not take me exactly on that cell.


any help will be appreciated

I added with Comma also, getting error message as # N/A

see below the formula
=ADDRESS(MATCH($B7,cost!B7:B30,0),,,"Cost")

not sure is this possible is excel 2010
just want column C in if I highlight any row would like to show me the where that linked thru Vlookup comes from, other sheet the one we used for Vlookup is there also,

if any one has any suggestion, please advise

thanks in advance for all your help

Enter the following in Sheet2 E7:

Please Login or Register  to view this content.

Copy and paste down from E7 to E18. Result will show as $C$12, $C$16, etc.