Hey team, have this formula that shows the number "0" while in the data tab no number shows...how can i change the formula to show a blank cell when no number shows on the data tab.
=IF(ISERROR(VLOOKUP($H11,Data,I11,FALSE)),"",VLOOKUP($H11,Data,I11,FALSE))
Thanks, Roy
=IF(ISERROR(VLOOKUP($H11,Data,I11,FALSE)),"",VLOOKUP($H11,Data,I11,FALSE))
Thanks, Roy