Reducing Nested Values

To put this simply I am trying to have Excel look up a column's worth of information and if the data matched then it will take the corresponding data in the specified row and place it in the box. For example:

My old formula would look like this:

=IF((N7=Data!B3),(Data!C3),IF((N7=Data!B4),(Data!C4),IF((N7=Data!B5),(Data!C5),IF((N7=Data!B6),(Data!C6),IF((N7=Data!Data!B7),(Data!C7),IF((N7=Data!Data!B8),(Data!C8),IF((N7=Data!B9),(Data!C9),,0)))))))

Theoretically I would love =IF(N7=Data!B3:B18,Data!C3:C18,0), but of course the value was 0.

N7 is where I would put in today's date. Data!B3 (and so on) would be where the current date should be compared with N7 and if it matches then corresponding number in column C would be displayed in the field. The problem is, however, doing this on a weekly basis is a bunch of extra work and I am wondering if there is a simpler formula to look up a year's worth of data, comparing it with the appropriate row in the appropriate column and putting that value in the cell.

Here is a picture of the cells that I am trying to grab info from: XL1.png

Thanks for all your help in advance!!

Didn't work like I was hoping. Here is another simplified version of what I am trying to do:XL2.png

Of course, Excel only lets me nest so much and I was hoping to get a year's worth of values in one box. This may be a stretch though lol.

I hope this helps. I inserted comments in the book and I hope I was clear enough.

Daily.xlsx

Here's the workbook with notes that should clarify what I am looking for.

Daily.xlsx

You are amazing! That is exactly what I was looking for! Thank you so much!