Auto Populate Adjacent Cell

[MrDB4Excel]

As you can see by the examples shown herein they are bogus to some extent and the amounts are all made up only to give results for the inherent formulas.
What I would like to do is when a dollar amount is entered in column “D” that the relevant formula looks to the Recurring Exclusion Type list in column “J” and then matches to the cell content in column “C” and ultimately returns an “R” or “NR”.
Obviously, any cell content in column “C” that does not exist within the “Recurring Exclusion Type” range and then the result to return in the “Label” column “E” would have to be “NR” as there is not a match.
You will also notice that the text in column “C” is sometimes based upon an equals formula, e.g. =TEXT(B5,”MMMM”)&” 2021”&” Health Insurance” thus this may be an issue but I am hoping not.
I have scoured the web for answers with these relevant queries: if a specific text is in a cell then fill in the adjacent cell with specific text; how to xlookup values based on adjacent cell value; and how to filter non-specific cells in excel. Everything I looked at did not seem to answer.
Any help will be much appreciated.

AutoPopulateAdjacentCells.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	NUMBER OR CODE	Date dd/mm/yyyyy	TRANSACTION DESCRIPTION	PAYMENT AMOUNT	Label	ü	ü	DEPOSIT AMOUNT or returns	BALANCE	Recurring Exclusion Type	Recurring Exclusion Values	LEGEND	LEGEND EXPLANATION
2						Debit	Credit					rd	regular deposit
3			Beginning Balance from end of 2020>>						$5,000.00	Health Insurance	$100	olp-dct	online purchase-debit card transaction
4	rd	Jan/06/2021	Cash deposit					$1,000.00	$6,000.00	Storage Rental	$100	ebp	electronic bill pay
5	ebp	Jan/08/2021	January 2021 Health Insurance	$100.00	R				$5,900.00	Electricity	$100	R	Regular Monthly or Annual Expense
6	ebp	Jan/12/2021	12-Mobile-Dec.pdf	$100.00	R				$5,800.00	Building Association Fee	$100	NR	Non-Regular Expense
7	ebp	Jan/14/2021	Storage Rental for January 2021	$100.00	R				$5,700.00	Internet Annual Billing	$100
8	ebp	Jan/14/2021	Electricity for January 2021	$100.00	R				$5,600.00	Annual Property Tax	$100
9	ebp	Jan/14/2021	Building Association Fee for January 2021	$100.00	R				$5,500.00	Mobile Phone	$100
10	ebp	Jan/14/2021	2021 Internet-Billing.pdf	$100.00	R				$5,400.00
11	olp-dct	Feb/01/2021	Amazon.com - Daliya Bebistep 4-in-1 Baby Walker	$100.00	NR				$5,300.00
12	rd	Feb/07/2021	Cash deposit					$1,000.00	$6,300.00
13	ebp	Feb/08/2021	February 2021 Health Insurance	$100.00	R				$6,200.00
14	ebp	Feb/12/2021	01-Mobile-Jan.pdf	$100.00	R				$6,100.00
15	ebp	Feb/14/2021	Storage Rental for February 2021	$100.00	R				$6,000.00
16	ebp	Feb/14/2021	Electricity for February 2021	$100.00	R				$5,900.00
17	ebp	Feb/14/2021	Building Association Fee for February 2021	$100.00	R				$5,800.00
18	olp-dct	Feb/24/2021	Amazon.com Johgee Laundry Drying Rack	$100.00	NR				$5,700.00
19	olp-dct	Feb/25/2021	Amtrak Tickets	$100.00	NR				$5,600.00
20	olp-dct	Feb/25/2021	Amtrak Tickets	$100.00	NR				$5,500.00
Sheet1

Cell Formulas
Range	Formula
C5,C13	C5	=TEXT(B5,"MMMM")&" 2021"&" Health Insurance"
C7,C15	C7	="Storage Rental for "&TEXT(B7,"MMMM")&" 2021"
C8,C16	C8	="Electricity for "&TEXT(B8,"MMMM")&" 2021"
C9,C17	C9	="Building Association Fee for "&TEXT(B9,"MMMM")&" 2021"
I4,I12	I4	=SUM(I3+H4)
I13:I20,I5:I11	I5	=SUM(I4-D5)

 

[MrDB4Excel]

I found the answer as follows:
=IF(ISNUMBER(MATCH(D6,$K$3:$K$9,0)),"R","NR")

 

[Joe4]

Glad you got it figured out!

Note, that in these formulas:
=SUM(I3+I4)
=SUM(I4-I5)
the SUM serves no purpose and is unnecessary. SUM does addition (+), so there is no reason to use both.

Your first formula should just be:
=SUM(I3:I4)
or
=I3+I4

And your second formula isn't summing/adding anything, so it should just be:
=I4-I5

Note that if you do use SUM (like you did), you will still get the correct answers, but it is completely unnecessary to do so. It adds nothing of value to the equation.

 

[MrDB4Excel]

Thanks Joe4, appreciate the input. My use of sum is just a bad habit I suppose. Some old dogs never learn.