Multiply by different number every month

[Granny]

On January 1st I am given goals in an excel worksheet, Broken down by month. For example in cell A18 is January, cell C18 is the percentage. Ex: 2.25%. February is in cell A19 and the percentage for February is in cell C19 Ex: 2.00%. March in cell A20 and so on. Every month is a new percentage. Then daily I import a number into cell B2 that I times by the percentage for the correct month. In cell C3 I have a formula that I have to change monthly. Example =B2*D18 for January in February I change the formula to B2*C19. Is there a way for excel to automatically change the formula for me on the 1st of every month?

[DBY]

Hello
If the months in column A are text values, you could use a VLOOKUP function to find the percentage for that month.

=B2*VLOOKUP(TEXT(TODAY(),"mmmm"),$A$18:$C$29,3,0)

Here your months and percentages are in the range A18:C29.

Hope this helps.
DBY

[Granny]

Thank you so much. It looks like it is going to work, if it returns correct values Monday when I open the worksheet in the new month I will close the thread if it does not recalculate I will let you know. Again Thank you!