Function that looks for a number that is in a colum next to a specific date.

Can anyone come up with a function that looks up a list of dates and finds the correct date, then gets information from the cell next to it? I am going to try to attach a file. In the file is an excel spreadsheet with two tabs. One is called Pod and the other is called Wallchart. In the POD sheet there is a yellow and a red highlighted cell. In the yellow cell I have a function that counts how many times a date is used in the range. What I want for the red cell is the numbers that are added up from the cell next to those three dates. So in wallchart tab I have the dates in cells W10:W128. In cells X10:X128 are numbers. I want those numbers that coresponds with the date. If I go back to the POD tab I can change the date in cell N1 and the yesterday, today, and tomorrow dates will change to match. I want each red cell to be able to change to the correct number that I change the date to. This sounds very confusing to me and if you find it the same then ask me questions so I can clear things up. excel help.xlsx

Hi,

Not quite sure but think that in cell D11 you're after:

=SUMIF(WallChart!W10:W128,YESTERDAY,WallChart!X10:X128)

etc.

Regards