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

%3CLINGO-SUB%20id%3D%22lingo-sub-1714272%22%20slang%3D%22en-US%22%3EFunction%20that%20will%20return%20value%20of%20a%20cell%20based%20on%20a%20date%20in%20a%20third%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714272%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20struggling%20with%20trying%20to%20get%20a%20range%20of%20cells%20to%20return%20a%20value%20from%20a%20call%20when%20the%20date%20matches%20in%20a%20second%20cell.%26nbsp%3B%20I%20have%20attached%20an%20example%20of%20what%20I%20have%20been%20struggling%20with.%26nbsp%3B%20Example%3A%26nbsp%3B%20I%20want%20a%20formula%20that%20would%20be%20placed%20in%20all%20of%20the%20cells%20in%20the%20range%20from%20D3%20through%20R15%20that%20would%20populate%20the%20value%20from%20column%20A%20into%20the%20corresponding%20date%20column%20based%20on%20the%20date%20contained%20in%20column%20B.%26nbsp%3B%20I%20tried%20using%20a%20nested%20IF%20function%20but%20could%20not%20get%20it%20to%20work.%26nbsp%3B%20Am%20I%20using%20the%20wrong%20function%3F%26nbsp%3B%20Is%20there%20another%20function%20that%20would%20be%20easier%20to%20use.%26nbsp%3B%20Searching%20the%20internet%20I%20have%20found%20no%20such%20solution.%26nbsp%3B%20Any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1714272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1714561%22%20slang%3D%22en-US%22%3ERe%3A%20Function%20that%20will%20return%20value%20of%20a%20cell%20based%20on%20a%20date%20in%20a%20third%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714561%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F809451%22%20target%3D%22_blank%22%3E%40James_Given%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20D3%3AU15.%20I'll%20assume%20that%20D3%20is%20the%20active%20cell%20in%20the%20selection.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20and%20confirm%20it%20with%20Ctrl%2BEnter%20to%20fill%20the%20entire%20selection%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(%24B3%3DD%241%2C%24A3%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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.

2 Replies
Highlighted

@James_Given 

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,"")

Highlighted

@James_Given 

 

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

 

 

Nikolino

I know I don't know anything (Socrates)