Error message #N/A

  • Thread starter Thread starter ISAF Media Analysis
  • Start date Start date
I

ISAF Media Analysis

Hello,

I am using the VLOOKUP formula below. However, in the frequently get the
#N/A error in the cells. Does anyone know how I can get rid of the error
without messing up the formula? Thanks in advance.

=VLOOKUP(G4,'LINES -- DO NOT TOUCH'!$A$1:$B$44,2,FALSE)
 
Hi,

=IF(ISNA(VLOOKUP(G4,'LINES -- DO NOT
TOUCH'!$A$1:$B$44,2,FALSE)),"",VLOOKUP(G4,'LINES -- DO NOT
TOUCH'!$A$1:$B$44,2,FALSE))

Mike
 
Thanks. It worked like a charm.

Mike H said:
Hi,

=IF(ISNA(VLOOKUP(G4,'LINES -- DO NOT
TOUCH'!$A$1:$B$44,2,FALSE)),"",VLOOKUP(G4,'LINES -- DO NOT
TOUCH'!$A$1:$B$44,2,FALSE))

Mike
Click to expand...
 
Hi,

A very good point, Thanks. It would only eveluate twice if the result of the
first VLOOKUP was FALSE.

Mike
 
Back
Top