If statement

[jlugo]

Hi,


Question 1.
I'm trying to build a data drop sheet. My goal is to create an if statement that reads the column headers and row headers. If both read a certain word "lets say a month & employee wage" then to return the value where they both intersect.

Question 2.
Same concept as above, but I'm trying to create a formula to scan for certain GL codes in the row headers. If these code are identified, then add each value up. (i.e. Column A headers GL codes 6310 + 6500 + 6510 + 6540, their values to the right - Column B $345, $456, $567, & $678).

Any help is appreciated.

 

[jamtay317]

this is the anwser the first question, and the second I think that I need some sample data to understand what you are talking about, can you please fill all borders around a small sample of the data, highlight it then copy and past it in here

Excel 2010
	A	B	C	D	E
1	Month	Employee Wage	Address	City	State
2	January	$10.00	123 main Street	that City	that State
3	February	$11.00	124 main street	that City	that State
4	March	$12.00	125 main Street	that City	that State
5	April	$13.00	126 main Street	that City	that State
6	May	$14.00	127 main Street	that City	that State
7	June	$15.00	128 main Street	that City	that State
8
9
10
11		February	Employee Wage	$11.00
Sheet1

Cell Formulas
Range	Formula
D11	=INDEX(B2:E7,MATCH(B11,A2:A7,0),MATCH(C11,B1:E1,0))

 

[jlugo]

Here is a sample of data:

		JAN	FEB	MAR
Exchange Rate Income/Loss-INR	6001	2,214	1,757	(431)
Exchange Rate Income/Loss-GBP	6002	1,203		1,568
Gain/Loss on Sale/Writeoff of Assets	6003		778	88
Other Non-Operating Income	6005	(6,514)	(8,286)	(13,469)
Employee Deferred Compensation Cost	6310	258	260	1,769
Discontinued Operation Expenses	6500	5,343
Facility Relocation Expenses	6510	41,299	60,894	5,106
Transaction Related Expenses	6520	7,344	5,058	1,060
Non-Recurring Legal Expenses	6530	9,536	1,938	235
Non-Recurring Personnel Expenses	6540	57,117	38,871	3,117
System Conversion Consulting Expenses	6550	12,410	7,410	10,755
Other Non-Recurring Expenses	6590	78,295
Suspense	9899			1,203
Other non-recurring (income)/expenses		75,198	(5,751)	(12,244)	Desired Results
Calculation - Other non-recurring (income)/expenses - (6001 + 6002 + 6003 + 6005 + 6590)

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

I am trying to create an if statement that would scan the column headers and scan the row headers that match the 6xxx account criteria. If it matches, it will perform either addition or subtraction type calculations.

Cell reference is not an option because rows are not static and always being switched around.