I have a vlookup formula that I am using in a couple different columns in my spreadsheet. The rows are filled out as the week progresses. It's a call log. When I drag the formula down, I get #N/A in the cells where there is no data yet. It really muddles up the worksheet. Is there a way to leave these incomplete functions from showing? I have tried formating the cell in the custom mode where you put in ;;; and it's supposed to hide the contents but that doesn't work. Any input would be appreciated. Thanks, Fledgling