Matching data in different sheets to return a value in a cell

Thanks Shijesh,

Unfortunately, this won’t work, i think the formula should have a combination of IF & MATCH functions, but I do not know how to get them done

Regards