I am using the formula =VLOOKUP(F4,Scoring!$B$3:$C$66,2,FALSE) in column 'G' to return values from another sheet, 'Scoring', if column 'F' has a name in it the value is returned. The problem is if column 'F' is blank the formula returns ### and I cannot SUM column 'G'. Help please. Yhank You!
Jim O
Bookmarks