View Single Post
  #1   Report Post  
JeaneIsaac
 
Posts: n/a
Default How do I remove the #div or N/A and make it 0 when using VLookup?

I have a very large worksheet that I am using the following vlook up on

=IF(ISNA(VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0)),0,VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0))
I am using the results of the lookup for another calculation, so I don't
want the return value from my look up to be N/A. Can you please tell me how
to make it 0 instead of the N/A when there is no match in the lookup sheet.
Thanks