how do i find any value in a list that is not #NA
 

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.

Any ideas?

how do i find any value in a list that is not #NA
 

So, there will only being a single value that is not #N/A?

=LOOKUP(2,1/NOT(ISNA(A1:E1)),A1:E1)

Biff

"Larry Lessmann" <Larry wrote in message
...
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.

Any ideas?

how do i find any value in a list that is not #NA
 

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)

how do i find any value in a list that is not #NA
 

One way

=INDEX(C3:O3,MATCH(FALSE,ISERROR(C3:O3),0))

entered with ctrl + shift & enter

will return the first cell with non error


--
Regards,

Peo Sjoblom



"Larry Lessmann" <Larry wrote in message
...
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.

Any ideas?