Searching table for text, when table contains blanks

[jimavet]

Hello. Very frustrated, as I've been working on this for several days.
I am working with a Profit & Loss statement from Quickbooks, and exporting that P&L to a spreadsheet. In doing so, Quickbooks arranges the P&L information into a total of 9 columns (and roughly 300 rows) of information; each row has a unique account name written in one of the columns. Thus, the 9th column is the dollar amount associated with a specific account that is listed in one of the first 8 columns - in other words., the account name that references that dollar amount (in the 9th column) might show up in any of the 8 columns, and the other 7 columns for that account row are blank. (I've verified the blank spaces are always blank and don't contain extra spaces/letters/etc.)

I need a formula (and have been trying index/match without success) that searches all the columns for a specific account name, and then returns the dollar amount from the 9th column once it finds the account name. The third post has a spreadsheet attached, and shows the example of what I'm trying to achieve.
An example of how the chart could look is:
Col1 Col2 Col3 DollarAmount
Income (blank) (blank) $100
(blank) Cash (blank) $200
(blank) (blank) Checks $300

So, if the search field had "Cash" written into it, I would want it to display "$200" as the result. The error I keep getting is that it says the formula "refers to empty cells".
Any assistance would be greatly appreciated!

[Apcal88]

Give an example? Looks like its a simple function. Attached a spread sheet that shows the data and the result you want.

[jimavet]

ExampleProfitLoss.xlsx
Here is a quick version of what I am working with. I have not set up any index names, but only created fictitious data to show what I want. The data from Quickbooks will be copied into the first three columns in this example. I will have pre-existing accounts listed in the tan-colored cells; the green-colored cells will then search the first three columns and match all the accounts listed in the tan-colored cells to display a summation result in the green-colored cells. In the spreadsheet I've attached the results in the green-colored cells have obviously been manually written in, to show you what the final display should look like. Thank you!

[jimavet]

Bumping in case anyone is able to help solve this for me - thanks!

[jimavet]

Help, anyone?