Trying to use IF function to gather specific data from 2 worksheets

Hi,

I am working on a spreadsheet which has a number of tabs (I attach a test sheet), On the Registration Tab, i am trying to use the IF Function in column L to make the cell either blank if coloumn M shows Open or if M shows Closed put the specfic value of corresponding cell from the Corrective action required Tab...

SO Registration Cell L2 would have the formula:

=IF(M2=Closed,'Corrective Actions Required'!I2,"") but this shows up a #NAME? error and any other attempt i have made to get the correct information into Cell L2 on the Registation tab brings all other errors up.

Ideally i would like the Date confirmed to either be blank or be the same value as Corrective Actions required tab date in column I...

Hope this all makes sense

Any assistance would be greatfully received,

Many Thanks

Emma

That was great, Thank you very much for your help