[AccessD] OT: Excel Function - VLOOKUP

Joe Rojas JRojas at tnco-inc.com
Wed Apr 26 12:51:40 CDT 2006


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



More information about the AccessD mailing list