[AccessD] OT: Excel Function - VLOOKUP

Joe,

You can use the ISNA() function:

=If(ISNA(<your vlookup function>),0,<your vlookup function>)

HTH,
Steve 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Wednesday, April 26, 2006 11:52 AM
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
--


This communication is the property of Qwest and may contain confidential or
privileged information. Unauthorized use of this communication is strictly 
prohibited and may be unlawful.  If you have received this communication 
in error, please immediately notify the sender by reply e-mail and destroy 
all copies of the communication and any attachments.