Thread: Return Column Name

I have a worksheet with over 200 columns and 3000 rows. It is like a ledger, where each column is a different account.

I need a formula for each row of my worksheet, that searches every column in that specific row until it finds one that has an unspecified number in it, and returns the name of the column with the number.

Sample:
Category Account 1 Account 2 Account 3 Account 4
Expense 1 Account 1 100
Expense 2 ? 200
Expense 3 ? 300

So I want it to return the name of the column that has the number in it as the name of the category as shown in the example for account 1. In other words category for expense 2 should be account 2 and category for expense 3 should return a text string that says "Account 4"

Is this possible, and can someone give me a template formula to do so, It would be greatly appreciated.

I have attached a sample spreadsheet to make the example more understandable

it just returns the value in the first column each time, but it's a start, thanks!