I m thinking a formula on the right side table I do have data validation on the drop down list on the top left
Thank You