How do I output the text in a cell that's in the same row as the highest number cell of a table in excel? -

sorry confusing title, i'm not sure how word this.

i have table full of names , data, let's 3 columns. 1 names, second dates, , third numbers. wanted find second highest number in whole column, think got large function.

but now, want to, in different sheet, make cell shows name or date second largest number found.

is there anyway go doing this?

for finding name can use:

=index(a:a,match(large(c:c,2),c:c,0)) 

and finding date can use:

=index(b:b,match(large(c:c,2),c:c,0)) 

this supposes names column a, dates b , numbers c. consider supposes numbers values unique otherwise find first occurrence of number. regards,