Error message #N/A

[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)

 

[Mike H]

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

 

[ISAF Media Analysis]

Thanks. It worked like a charm.

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

 

[Mike H]

Hi,

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

Mike