One way to match any number larger than possible in your row.
=INDEX(3:3,MATCH(9999999,3:3))

--
Don Guillett
SalesAid Software

"WINDMILL" wrote in message
...
Does anyone know of a method to return the value of the last nonblank cell
in
a row?
I have a running total spreadsheet that contains links to other workers,
the
value that I need in the reference cell has to be the last value in the
row,
it may be b22 then next time c22, d22 etc
all suggestions appreciated.