Larry Lessmann <Larry wrote...
I have a row of cells on one sheet, each of which is the result of a vlookup.
I want to retrieve the (hopefully) one value in the row that is NOT #NA.
The value can be anything, so I don't have the lookup_value for hlookup.

Try something like

=LOOKUP(2,1/(1-ISNA(A1:J1)),A1:J1)