Sep 25 2020 12:13 PM
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.
Sep 25 2020 12:59 PM
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,"")
Sep 25 2020 01:11 PM
Solution
If I may, I would like to add this suggestion as well.
Nikolino
I know I don't know anything (Socrates)
Sep 14 2022 10:15 AM
Sep 25 2020 01:11 PM
Solution
If I may, I would like to add this suggestion as well.
Nikolino
I know I don't know anything (Socrates)