Joe Rojas
JRojas at tnco-inc.com
Wed Apr 26 15:45:34 CDT 2006
Thanks to everyone for the quick responses! Thanks, Joe Rojas IT Manager TNCO, Inc. 781-447-6661 x7506 jrojas at tnco-inc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Long, Karen S. (CDC/NIOSH/NPPTL) (CTR) Sent: Wednesday, April 26, 2006 2:26 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OT: Excel Function - VLOOKUP =IF(ISNA(VLOOKUP(E2,$A$2:$C$5,3,FALSE)),0,VLOOKUP(E2,$A$2:$C$5,3,FALSE)) would return 0 I use this site for referencing formulas, etc. http://www.techonthenet.com/excel/formulas/vlookup.php The main menu is: http://www.techonthenet.com/excel/formulas/index.php Karen S. Long Programmer Analyst EG&G Technical Services, Inc. Pittsburgh, PA Phone: 412-386-6649 Email: cyx5 at cdc.gov -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas Sent: Wednesday, April 26, 2006 1:52 PM To: Access Developers discussion and problem solving Subject: [AccessD] OT: Excel Function - VLOOKUP Hi All, I have an Excel question. The VLOOKUP function returns "#N/A" if it cannot find a matching value. I was trying to wrap the VLOOKUP function in an IF statement to test if it returns #N/A so I could output a zero instead of #N/A. Does anyone know exactly what value to test for? I tried "#N/A", '#N/A', #N/A, and FALSE but none these worked. Thanks, Joe Rojas IT Manager TNCO, Inc. 781-447-6661 x7506 jrojas at tnco-inc.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com