Forum Discussion
Solved
Function that will return value of a cell based on a date in a third cell
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. Exam...
If I may, I would like to add this suggestion as well.
Nikolino
I know I don't know anything (Socrates)
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:
=IF($B3=D$1,$A3,"")