Hello,


After I use the formula =IFERROR(VLOOKUP(A2439,PEIHIERARC_Hierarchy_to_Cost_Ce!K:O,5,FALSE),""), the cells with that appear blank because of the "" , are still not treated as blank cells by excel.

is their a macro that can identify in a certain cell range which cells are "" and actually clear them to be truly blank?

thanks,

Lorenzo