Current price from multiple columns

[SRMPURCHASE]

Which formula would return in Column Q the first value to the left in that row back to Col A.
I have numerous columns of price history from a vendor and I would like to use Col Q to reflect the current price, which would be the first value to the left of Col Q in that row.

 

[Joe4]

Have a look at the formulas shown here: https://www.extendoffice.com/docume...-first-last-non-blank-cell-in-row-column.html

 

[SRMPURCHASE]

=INDEX(RANGE,MATCH(TRUE,INDEX((RANGE<>0),0,0))) works in some instances, however, I seem to have an issue with the blank cells.
What is the proper designation of a "blank" cell. A numerical zero, one space bar then enter or......????

 

[Joe4]

If they are totally blank (no space, no zero), the formula should work.
If it does not, I suspect that you have something in that cell.

Youcan easily comfirm with the LEN function, i.e. if checking cell C1, try putting
=LEN(C1)
in any unused cell, and see what it returns.
If it returns anything other than zero, then C1 is not really blank - there is something in it.

 

[SRMPURCHASE]

K Thanks Checking