packieBrass ContributorJul 12, 2024Return value from whichever cell contains a value based on two cellsHi, Only one cell from colE or colF will contain a value What formula will I use to return a result in colG Examplee8="" f8="pink" g8="pink"e9="red" f9="" g9="red" The result returned in colG is pink and red Thankyou for your interest. Detlef_LewinJul 12, 2024packie =E8&F8