|Have you read the Help files on VLOOKUP?|
I am assuming that your dates are in Column A and the sales goals are in Column B.
With your dates in Column A, the formula I offered will return the value from Column B associated with the date that matches TODAY().
The 2 used as the col_index_num argument means to return the value from the second column of the lookup_array, which is A1:B20.
If you are using some other columns, change the lookup_array argument to match, as long as the dates are in the left hand column and your sales goals are to the right of that.
If you have something totally different, then you'll need to describe your set up in more detail.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.