| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with #N/A
How do I write a vlookup that works for n/a
IF(F45=--#N/A;1;0) Above one does not work br sverre |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correction-should be IF with na not vlookup
Sorry, wrong of me....
Below does not work when there is na. Can I correct it? =IF(--F8="#N/A";1;0) f8 is by the way a Vlookup that has catched a number. sverre br sverre |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correction-should be IF with na not vlookup
Use the ISNA() function to test for #NA
-- Kind regards, Niek Otten Microsoft MVP - Excel "sverre" wrote in message ... | Sorry, wrong of me.... | | Below does not work when there is na. Can I correct it? | | =IF(--F8="#N/A";1;0) | | f8 is by the way a Vlookup that has catched a number. | | sverre | | | br | sverre |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correction-should be IF with na not vlookup
Try this:
=IF(ISNA(F8);1;0) or =--ISNA(F8) Does that help? *********** Regards, Ron XL2002, WinXP "sverre" wrote: Sorry, wrong of me.... Below does not work when there is na. Can I correct it? =IF(--F8="#N/A";1;0) f8 is by the way a Vlookup that has catched a number. sverre br sverre |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correction-should be IF with na not vlookup
Yes
Works fine. Thanks Sverre "Ron Coderre" skrev: Try this: =IF(ISNA(F8);1;0) or =--ISNA(F8) Does that help? *********** Regards, Ron XL2002, WinXP "sverre" wrote: Sorry, wrong of me.... Below does not work when there is na. Can I correct it? =IF(--F8="#N/A";1;0) f8 is by the way a Vlookup that has catched a number. sverre br sverre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
