Drop down list based on multiple conditions

I have an excel report with a raw data table and would like to call the values from this tab to another one based on multiple conditions

If there is no value or error the cell need to return blank""

same as attached, This will be a great help If some help me on this

Thanks & Regards
Praveeen

hi

please find attached