| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look up error handling question.
I am trying to do a look up that is return a value of “” if there is an #N/A error (the data does not exist) but this formula is not working for me. Any ideas? =IF(VLOOKUP(O8,'[xx.Data.xls]XXXXX Valley'!$L$1:$R$100,2,FALSE)=ISNA(V1),"",(VLOOKUP( O8,'[xx.Data.xls]XXXXX Valley'!$L$1:$R$100,2,FALSE))) Thank you for your help. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=541573 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Look up error handling question.
Typo
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(..)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Ardus Petus" wrote in message ... IF(ISNA(VLOOKUP(...),"",VLOOKUP(...)) HTH -- AP "sungen99" a écrit dans le message de news: ... I am trying to do a look up that is return a value of "" if there is an #N/A error (the data does not exist) but this formula is not working for me. Any ideas? =IF(VLOOKUP(O8,'[xx.Data.xls]XXXXX Valley'!$L$1:$R$100,2,FALSE)=ISNA(V1),"",(VLOOKUP( O8,'[xx.Data.xls]XXXXX Valley'!$L$1:$R$100,2,FALSE))) Thank you for your help. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=541573 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Look up error handling question.
Works! thank you! -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=541573 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Look up error handling question.
does not seem to work. in my test i should return a "" but im still getting the #N/A error. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=541573 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling | Excel Programming | |||
| Error Handling question | Excel Programming | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| question error handling | Excel Programming | |||
| Error handling with a handling routine | Excel Programming | |||
![sungen99[_104_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
