Avoiding the #N/A when performing VLOOKUP

  • Thread starter Thread starter Jason Mathews
  • Start date Start date
J

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
 
Jason,

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

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

John
 
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
 
Back
Top