If you can accept helper cells like in sheets 1:4, H3:I28 and sheet Dashboard H2:H5 then you might want to take a look at the attached workbook. Helper cells can be hided or moved to somewhere out of sight if you want.

Attached Files

3D_Lookup_3.xlsx (20.6 KB, 6 views)

This works great thank you!!

In the document I will actually be using - each sheet will have about 8 columns and for the latest record of each company I would like to bring back all columns associated with the company.

I added an extra column on sheet 1,2,3,4 but when I try to bring the most recent one back onto the dashboard it just comes back with '0' (obviously I am doing it wrong!!).

Do you know how I could add extra columns and bring them all back as well as the date?

Again thank you soo much for this I have been so stuck.

Please upload a workbook with full data set.

I actually can't post the real data as it's confidential but I have added more of the sample columns which match those I will be using in the doc.

It's for a telesales call tracker type thing. I have 4 userforms which submit call records and those records will be linked into this document (the table will be linked and set to refresh data every 5 mins or so) so this dashboard will be used to keep an overview of all of the companies they will ring without needing to see all records for them.

Attached Files

3D_Lookup_2 added columns.xlsx (23.4 KB, 7 views)