Function that will return value of a cell based on a date in a third cell

Occasional Visitor

I have been struggling with trying to get a range of cells to return a value from a call when the date matches in a second cell.  I have attached an example of what I have been struggling with.  Example:  I want a formula that would be placed in all of the cells in the range from D3 through R15 that would populate the value from column A into the corresponding date column based on the date contained in column B.  I tried using a nested IF function but could not get it to work.  Am I using the wrong function?  Is there another function that would be easier to use.  Searching the internet I have found no such solution.  Any help would be greatly appreciated.

3 Replies


Select D3:U15. I'll assume that D3 is the active cell in the selection.

Enter the following formula and confirm it with Ctrl+Enter to fill the entire selection:



best response confirmed by Hans Vogelaar (MVP)



If I may, I would like to add this suggestion as well.




I know I don't know anything (Socrates)