Forum Discussion
James_Given
Sep 25, 2020Copper Contributor
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. 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.
If I may, I would like to add this suggestion as well.
Nikolino
I know I don't know anything (Socrates)
- NikolinoDEGold Contributor
If I may, I would like to add this suggestion as well.
Nikolino
I know I don't know anything (Socrates)
- rodrigomonchosCopper ContributorWorks great, thank you so much!
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,"")