Have a table with Price & Purchases by Qtr:

A B C D
E F
QTR1$ Qtr1Vol QTR2$ Qtr2Vol Qtr3$ Qtr3Vol

Row5 $1.00 5000 $1.10 5500 $1.12 5300
Row6 $2.20 2500 $2.22
2600

Is there a function that will evaluate colum A row5 , C5, E5 and return the
first one (left to right) that has a value?

In the example above Row 5 = $1.00 and Row 6 = $2.20

The above is a very simple example but the real data will have about 20
columns to evaluate.