Hi,

The INDEX/MATCH formula below works great:

=INDEX(Table_TEAMWORKS_25657_HYDRO5[TEST_PREPARATION],MATCH('OSBL Testpacks'!A2,Table_TEAMWORKS_25657_HYDRO5[PKG_ID],0))

I now need to include an IF so that if there is no value (a date) in the cell in Table_TEAMWORKS_25657_HYDRO5[TEST_PREPARATION] it returns nothing. A present if there is no date it returns “0”. I want either a date or nothing.

I have tried adding an IF but can’t get it working. How would I need to modify my formula to include this IF?

Thanks very much

Dave