IF & INDEX Formula =INDEX(D11:D59,COUNTA(D11:D59),1)

Morning All,

I have worked out to do an Index function to return the last name in a column but i need this to be based on the value in column C. This is essentialy an equipment register and we need to track who has what, each tab is a different piece of equipment. Column A has the issued date, column B is the returned date and column D is the current user - each row represents a new lease. What i would like to do is work out with ease who has the equipment, if there is no return date then the last user in cloumn D is responsible?

=INDEX(D11:D59,COUNTA(D11:D59),1)

Thanks

i tried this too

=IF(B11:B59,"",INDEX(D11:D59,COUNTA(D11:D59),1))

Book2.xlsx

Thanks Martin

I am lost for words!!!!! THANK YOU