If statement is false skip to next row

So here's the deal. I've used Excel quite extensively, but not like this when it comes to programming certain things. I'm in a bit of a rut right now.

The company I work for has a calendar made in excel. It just has the date up top, and about 8 empty rows below the date broken into 2 columns. In the left hand column goes the item, in the right hand column goes the price.

This is where I'm lost. This information is changed weekly, and to make it easier on the mangers they want to be able to add info into a secondary sheet and have it autofill. I thought this wouldn't be a problem but it's turned out to be trickier than I thought.

My first thought was VLOOKUP, but that was quickly squashed because the spreadsheet has the date repeated as many times as there are items, so it always just pulls the first item.

Then I went to an IF statement. This worked out well, but since I can't figure out how to tell it to skip the to next row if it is false, by the third day I have a bunch of blanks that won't work.

I'm not familiar with VBA, but I'm willing to try. I am really just looking for an IFFALSE statement that will allow me to skip that row and go to the next one, as opposed to giving me a bunch of blank lines. Any ideas?

Thanks in advance!