| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last value in list | Excel Worksheet Functions | |||
| How to find a find a list of possible inputs to sum a known amt? | Excel Discussion (Misc queries) | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| Find in a list | Excel Discussion (Misc queries) | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Linear Mode
