Hi All,

I have a very basic knowledge of excel but as I know where the power button on a pc is work seems to think I'm a computer genius.
I have been tasked with setting up something which shows if someone has not been on a certain job for a while (basically a rota).

For this I was hoping to set up a spreadsheet that looks across multiple sheets and brings back the most recent date only when someones name is in another field.

I have this so far:

This works
=IF(First!F2=Sheet2!A2,(MAX(First:Last!B2)),"no answer")


This doesn’t
=IF(First:Last!F2=Sheet2!A2,(MAX(First:Last!B2)),"no answer")

F2 is where I put the person on the "rota", A2 is the the list of names, B2 is the date.

Problem with the first one is the IF part of the statement only looks at one worksheet and not the range as desired.

Any help would be appreciated but my understanding of excel is not great.
There is no sheet to upload as haven't really made one as cant get the basic principal to work.

Thanks for your help in advance

M