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

khanaran

New Member
Joined
Oct 24, 2012
Messages
20
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
match and paste.png
 

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
Joined
Jun 12, 2014
Messages
56,816
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
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?

Disable AdBlock

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
Top