# Formula based on date reference

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
I need a formula in C2:C6 that will find the value in cells B8:B15 based on the corresponding date i.e. in cell C2 rather than B2*B11 it needs to be more like B2*... match the date in A2 with A11 then multiply B2 by B11

The reason being the dates in A2:A6 and A8:A15 will not always be sequential.

Thanks

Try:
Copy C1 down as needed.
Excel Workbook
ABC
15-Jul-154,3202,138
26-Jul-154,6002,392
37-Jul-154,2002,016
48-Jul-155,0002,525
59-Jul-154,6502,465
6
72-Jul-1554.00%
83-Jul-1555.50%
94-Jul-1551.00%
105-Jul-1549.50%
116-Jul-1552.00%
127-Jul-1548.00%
138-Jul-1550.50%
149-Jul-1553.00%
Sheet

Thanks.

This is my formula from the full worksheet;

=IF(G13>TODAY(),"",IF(\$P13=0,0,(((\$S13*AH224)+(\$AE13*P431)+(\$AN13*AH431)+(\$AW13*AW431)+(\$BF13*BL431))*(1-BX13))/\$CD13))

For the above example substitute the \$S13 for B1 & the AH224 for B7.

Can your vlookup formula be embedded into the formula above ?

You would want to replace AH224 with the VLOOKUP formula.

Replies
10
Views
882
Replies
4
Views
3K
Replies
2
Views
158
Replies
3
Views
187
Replies
0
Views
563

1,203,401
Messages
6,055,182
Members
444,768
Latest member
EMGVT

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back