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.
Hi, 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. Read More
