I was trying to use COUNTIF within the formula, but adding the column works.
This is the formula that I have used to get the actual data after adding your suggestions.
=IF(ISERROR(VLOOKUP(ROW(A17)-16,Sales!$A$5:$H$17,4,0)),"",VLOOKUP(ROW(A17)-16,Sales!$A$5:$H$17,4,0))
I'll mark this solved later, just in case any other suggestions are forthcoming
Thanks Cutter
Bookmarks