Thanks NBVC! That modification works.

However, this is kinda embarassing! :/ I have just realised that my formula is pretty screwy as currently it will only display a result if the condition I selected matches the value of A8 of the Data Entry - Blast spreadsheet. When i changed my formula range to "Data Entry - Blast'!$A$9:$A$65000" then it will only display a result if the condition matches the value of A9.

Anyone knows what's wrong and how to fix this please?