Forum Discussion
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....
- I think I have worked out the answer. Seems to work:
=(INDEX($E$2:$E$155, MATCH(A2,$D$2:$D$155,0)))*B2
I think I have worked out the answer. Seems to work:
=(INDEX($E$2:$E$155, MATCH(A2,$D$2:$D$155,0)))*B2
=(INDEX($E$2:$E$155, MATCH(A2,$D$2:$D$155,0)))*B2