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 |