Forum Discussion

packie's avatar
packie
Brass Contributor
Jul 12, 2024

Return value from whichever cell contains a value based on two cells

Hi,

 

Only one cell from colE or colF will contain a value 

 

What formula will I use to return a result in colG

 

Example

e8=""   f8="pink"   g8="pink"

e9="red"   f9=""   g9="red"

 

The result returned in colG is pink and red

 

Thankyou for your interest.