Match a value and work on a formula and paste the result into cell

[khanaran]

Greetings

I am struggling with trying to get a formula that will help to do the following
we have the date broken down into individual cells , D D = AN1 and AO1
from AN1 to AU1

In the table , an identifier is indicated from F9 to P9 /Q9 toAA9 and finally from AB9 to Al9

We need to look at the first two digits of the DD ie AN1 and AO1, if the day is from the
1st of the month to the 9th of the month, we ignore the D D

From the 10th day of the month to the end of the month, we will now sum the two digitd ie D+D
and if its greater than 9 , we mod it to a single digits

We will get an answer, this answer we need to match , wth the identifier and then place in cell
below the highlighted yellow cell
for example if N9 = 4 and the result from the calculation is 4, we paste the 4 into N10

Likewise, we do the same for Y9 and Y10 and AJ9 and AJ 10

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Match a value against a date and enter the matched value - OzGrid Free Excel/VBA Help Forum
and Calculate the value and paste into a cell using a formula [SOLVED]
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.