Please help me understand how to make this ISNAFind function, eg: =ISNAFind(A6,"PUB_HVA_Summary_Day","HVA_Summary_Day_Flot_Recovery_UnitEfficiencyAu_pct", DataRange) works. I have a e-base data management software and want excel to extract data into excel. The look up cell A6 could be date to look up. How do I make it work?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Function ISNAFind(...) to extract data from web database
Yongle
Well-known Member
- Joined
- Mar 11, 2015
- Messages
- 6,977
- Office Version
- 365
- Platform
- Windows
Not really sure what you are trying to do... 
But
if FIND does not find what it is looking for it does not return #N/A - it returns #VALUE!
FIND function has a maximum of 3 arguments, but you are trying to use 4
=FIND(FindText,WithinText)
- with an optional 3rd argument to start at a specific character position (an integer value)
To avoid error being returned, can wrap in IFERROR like this
=IFERROR(FIND(FindText,WithinText),"Not Found")
But
if FIND does not find what it is looking for it does not return #N/A - it returns #VALUE!
FIND function has a maximum of 3 arguments, but you are trying to use 4
=FIND(FindText,WithinText)
- with an optional 3rd argument to start at a specific character position (an integer value)
To avoid error being returned, can wrap in IFERROR like this
=IFERROR(FIND(FindText,WithinText),"Not Found")
Upvote
0
Similar threads
- Question
- Question
