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
Bookmarks