hi, is there a way to have a vlookup see an empty cell and rather than
filling it in with a 0 it could leave it blank? here's my vlookup formula

=IF(A21="","",VLOOKUP(A21,'PN Source Code'!$A$1:$H$25,8,FALSE))

Thank you in advance for your help :)