Forum Discussion
Solved
Eliminate #N/A in Index Match that looks at a List
Here is my https://1drv.ms/x/s!Am-hfuhzP9qmgapc0okpIfjbREi2MA
(shoot - the formulae disappear in the link). Here they are:
Col1:
=INDEX(CountryList,MATCH(TRUE,ISNUMBER(SEARCH(CountryList,OrigD...
Hi Lisa,
Easily, you can wrap the formula with one of these functions:
- IFNA
- IFERROR
Examples:
=IFNA(INDEX(CountryList,MATCH(TRUE,ISNUMBER(SEARCH(CountryList,OrigData!O18)),0)),"")
=IFERROR(INDEX(CountryList,MATCH(TRUE,ISNUMBER(SEARCH(CountryList,OrigData!O18)),0)),"")
NOTE: IFNA is available in Excel 2013 or later.
Hope that helps
Haytham
Hi Lisa,
Easily, you can wrap the formula with one of these functions:
- IFNA
- IFERROR
Examples:
=IFNA(INDEX(CountryList,MATCH(TRUE,ISNUMBER(SEARCH(CountryList,OrigData!O18)),0)),"")
=IFERROR(INDEX(CountryList,MATCH(TRUE,ISNUMBER(SEARCH(CountryList,OrigData!O18)),0)),"")
NOTE: IFNA is available in Excel 2013 or later.
Hope that helps
Haytham
- Haytham. That did the trick.
Thank you, not just for giving me an answer, but for helping out others who need help. Your time and effort are appreciated.
