I need help with the following... I have a vlookup that the return value is N/A, which I believe is correct since the lookup value has no results for the particular date. When I need to calculate column D and delete column I the results populate in column K. However, when the is no value in column I the sum does not populate in column K which should be the value in column D. I attached the worksheet for a sample.
Bookmarks