Looking through multiple columns for a value and entering a specific number based on the column with a value

[amitk1]

Hi everyone, happy to be a part of the community.

My question is I have a dataset of about 2,500 transactions. I have allocated these transactions to specific accounts and separated them according to column, there are 25 columns that are currently in use for the allocation.
Is it possible for a formula to check if any of these columns have a value greater than 0 and if they do, enter a specific text based on the column?

For example,
Transaction 1 is a bank charge, it is in column D, the excel formula will look through each column and once it finds a value in column D it will return the text '5550'
Transaction 2 is a rental payment, it is in column A, the excel formula will look through each column and once it finds a value in Column A it will return the text '4202'

I will need to be able to edit the text it returns back, not sure if this is even possible so was looking for guidance on the subject.

Please let me know if there is anything I can explain better, thank you.

 

[kweaver]

Welcome to Mr. Excel,

If would help if you used XL2BB to post a representative selection of your data with expected results.

 

[amitk1]

Hi, thank you for the warm welcome!
I have installed XL2BB and made a test worksheet, hope this helps!
I am curious about emulating the results in Column M as a formula

					4000	5050	3030	2025	4010	9034	2020
Date	Name	Cheques and Debits	Deposits and Credits	Balance	Sales	Accounting	Advertising and Promotion	Vehicle Lease	Bank Service Charges	Meals and Entertainment	Office Expense	ACCOUNT
				$ -
2022-11-05	Facebook Ads	$ 603.54		-$ 603.54			$ 603.54					3030
9/4/2022	Accounting Corporation	500		-$1,103.54		500						5050
3/30/2022	John K		4000	$ 2,896.46	4000							4000
1/25/2022	Mazda	300		$ 2,596.46				300				2025
6/30/2022	Mcdonalds	20		$ 2,576.46						20		9034
4/4/2022	Staples Office Supplies	60		$ 2,516.46							60	2020
8/16/2022	Royal Bank of Canada	15		$ 2,501.46					15			4010

 

[amitk1]

Apologies for the double post, by Column M I mean the Account column.

 

[kweaver]

What about

=FILTER($F$2:$L$2,SUM(C5:D5)=$F5:$L5)

or even shorter and better, I suppose:

=FILTER($F$2:$L$2,""<>F5:L5)

 

[amitk1]

This worked like a charm. I really appreciate this.

Thank you