Updating a list and totally confused

[MrDil]

I am guessing this might be easier than I thought, but I still can't figure it out. Here is my sheet as I can't install XL2bb.

Columns A through C are imported in. D is a sort and unique formula. I use a dropdown from a list (G) to populate E with the Merchant Category.

If I import new data into Column A, my sort will work in Column D, but its associated Business Type (Col. E) from the dropdown will not move with the data in Col. D.

How can I do this?

Thanks so much!

Column A	B	C	D	E	F	G
Date	Merchant	Amount (Dollars)	=SORT(UNIQUE(b2:b1000))	Dropdown from Col G.		Merchant Category
1/1/24	CD Iron Works	14,000	Best Woods Grounds	Business < 50		Gov't
1/2/24	Blue Collar Inc.	18,125	Blue Collar Inc.	Business > 50 miles		Business < 50
1/8/24	Best Woods Grounds	6,519	CD Iron Works	Business < 50		Education
1/9/24	City of Springfield	23,457	City of Springfield	Gov't		Charity/NFP
1/9/24	Blue Collar Inc.	3,420				Business > 50 miles
New data	New data	New Data
1/15/24	CD Iron Works	5,000

 

[StephenCrump]

I use a dropdown from a list (G) to populate E with the Merchant Category.

What do you mean by this?

For example, how do you determine that Best Woods Grounds is category "Business < 50"?

 

[MrDil]

What do you mean by this?

For example, how do you determine that Best Woods Grounds is category "Business < 50"?

Column g is a simple table. I have a drop-down menu in column e to manually choose what type of business category it is. This is why I am having the issue. I want to keep the data from D and E to stay together, but if I add new Data, the data from e will not be correct.Hope this makes sense

 

[StephenCrump]

I suggest you set up a separate lookup table for the business type:

	A	B	C	D	E	F	G	H	I
1	Date	Merchant	Amount (Dollars)	Unique	Dropdown from Col G.		BusinessType
2	1/01/2024	CD Iron Works	14,000	Another new merchant	Please update BusinessType table!		Best Woods Grounds	Business < 50
3	1/02/2024	Blue Collar Inc.	18,125	Best Woods Grounds	Business < 50		Blue Collar Inc.	Business > 50 miles
4	1/08/2024	Best Woods Grounds	6,519	Blue Collar Inc.	Business > 50 miles		CD Iron Works	Business < 50
5	1/09/2024	City of Springfield	23,457	CD Iron Works	Business < 50		City of Springfield	Gov't
6	1/09/2024	Blue Collar Inc.	3,420	City of Springfield	Gov't
7		New merchant	1111	New merchant	Please update BusinessType table!
8		Another new merchant	2222
9	1/15/24	CD Iron Works	5,000
10
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=SORT(UNIQUE(B2:B9))
E2:E7	E2	=IFERROR(VLOOKUP(D2#,BusinessType,2,),"Please update BusinessType table!")
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
BusinessType	=Sheet4!$G$2:$H$5	E2