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)

 

[Pecoflyer]

Hello,

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

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

Try

=if(countif(g4,$a$1:$a$44),VLOOKUP(G4,'LINES -- DO NO
TOUCH'!$A$1:$B$44,2,FALSE),0

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[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

 

[Pecoflyer]

Thanks. It worked like a charm.

Fyi, the ISNA method works perfectly but is not very efficient as th
VLOOKUP function must be calculated each time.
If you have many formulas in your sheet it will slow calculation
dramatically

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Mike H]

Hi,

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

Mike