Forum Discussion

BrentP2020's avatar
BrentP2020
Copper Contributor
Oct 31, 2022
Solved

Formula that will return value of a cell based on a date in a third cell that it can then multiply

Hi. Fairly new to excel and can't for the life of figure out the formula I need to do the following.   I want to take the date in from column A (say cell A2) and match it with the date in column D....
excel
Formulas and Functions
  • BrentP2020's avatar
    BrentP2020
    Oct 31, 2022
    I think I have worked out the answer. Seems to work:
    =(INDEX($E$2:$E$155, MATCH(A2,$D$2:$D$155,0)))*B2
BrentP2020's avatar
BrentP2020
Copper Contributor
Oct 31, 2022

Opps try the attached spreadsheet. Pasted incorrectly in previous version!
So for example the result for cell A4 should be B4 (0.1952) * E6 (1.403312)

 

Thanks again

Brent

Resources