View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ISAF Media Analysis[_2_] ISAF Media Analysis[_2_] is offline
external usenet poster
 
Posts: 21
Default Error message #N/A

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)