Avoiding the #N/A when performing VLOOKUP

[Jason Mathews]

I can not figure out how to change #N/A to a 0, when using
VLOOKUP and the lookup_value is not present on the
table_array.

I am completing a file that has a name and multiple
columns of data, and each column of data refers to a
different table_array. Each lookup_value is not present on
each table_array.

Jan Feb Mar Apr
Client One $$$ $$$ #N/A #N/A
Client Two #N/A $$$ $$$ $$$
Client Three $$$ #N/A $$$ #N/A

 

[John Wilson]

Jason,

=IF(ISNA(yourlookup),0,yourlookup)

an example:
=IF(ISNA(VLOOKUP(D1,A1:B4,2,FALSE)),0,VLOOKUP(D1,A1:B4,2,FALSE))

John

 

[Gord Dibben]

Jason

Example only, your cell refs will differ.

=IF(ISNA(VLOOKUP(C1,A1:B5,2,FALSE)),0,VLOOKUP(C1,A1:B5,2,FALSE))

Gord Dibben Excel MVP - XL97 SR2 & XL2002