Return first non-empty value in a range
I am attempting to write a formula that will search through row data and return the first non-empty value it finds. In the example below, the cell for city is where the formula will be placed. It should scan the rows [AZ Cities]@row:[CA Cities]@row and return Yorba Linda.
If the state was AZ, The [CA Cities] row would be blank and the formula might return Phoenix.
Appreciate any help you might be able to provide.
Help Article Resources
Check out the Formula Handbook template!