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

#### khanaran

##### New Member
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

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### Fluff

##### MrExcel MVP, Moderator
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.

Replies
6
Views
202
Replies
1
Views
111
Replies
1
Views
160
Replies
6
Views
99
Replies
16
Views
379

1,130,083
Messages
5,639,977
Members
417,120
Latest member
Pavithra devi

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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