Hi forum,

I am using below vlookup formula but if value comes to #N/A I want there "0" to be displayed.

=VLOOKUP(B8,raw1!B:I,8,0)/100000


Thank you