Return y or n based on a particular column, if multiple criteria match

Hi,

I have attached a Sample Workbook.
Now, it's not the easy IF and match criteria.

I have to look in 3 different columns and match and see in column F, if it is Y, N or blank... and based on the F column, return the value.


It's a bit complicated one! please check if someone can help me out! if not by functions then vba is also fine.