Using MAX to find date and using this in a formula to find what was updated last

[ashl]

Hi,

Sorry, new question...

I've used the max formula referencing the 3 date columns in the 3 tables on different sheets of my workbook to find out the date of when the latest update was made.

Works great, now i want to somehow use this as a reference in a formula which will give me the serial number of what was last updated. In each worksheet, the colum header of the serial number is named differently for eg, sheet 1,Table 1; Serial Number, Sheet 2; Table 1; Serial Number 2 etc etc

Any ideas on how this can be done using no VBA or volatile formulas? I was thinking index and match but I'm not quite sure how to put it together.

Can anyone help please?

Thanks,

 

[Faseeh]

Hi ashl,

Consider uploading sample file with your requirements and desired output. Thanks