I am very new to the index match function. I am trying to pull a particular cell in a specific row of data that matches a certain criteria.
I am pulling summarized data from an large excel for financial statements.
The formula I have is: =INDEX(bs!$AF$3:$AF$300,MATCH('Irish Test'!L4,bs!$C$3:$C$300,0))
I am wondering if instead of using C3:C300 if I can use a range of columns more like A3:G300
[TABLE="width: 387"]
<tbody>[TR]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]ASSETS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]Current Assets
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Checking/Savings
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00C · WASHINGTON FEDERAL - C
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00E · WASHINGTON FEDERAL - E
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00H · WASHINGTON FEDERAL - H
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00I · WASHINGTON FEDERAL - I
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]103-00E · VANGUARD TAX EXEMPT M/M - E
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]103-00H · CASH - VANGUARD TAX EXMPT M/M
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]103-00I · VANGUARD TAX EXEMPT M/M - I
[/TD]
[/TR]
</tbody>[/TABLE]
I am pulling summarized data from an large excel for financial statements.
The formula I have is: =INDEX(bs!$AF$3:$AF$300,MATCH('Irish Test'!L4,bs!$C$3:$C$300,0))
I am wondering if instead of using C3:C300 if I can use a range of columns more like A3:G300
[TABLE="width: 387"]
<tbody>[TR]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]ASSETS
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]Current Assets
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Checking/Savings
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00C · WASHINGTON FEDERAL - C
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00E · WASHINGTON FEDERAL - E
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00H · WASHINGTON FEDERAL - H
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]102-00I · WASHINGTON FEDERAL - I
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]103-00E · VANGUARD TAX EXEMPT M/M - E
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]103-00H · CASH - VANGUARD TAX EXMPT M/M
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]103-00I · VANGUARD TAX EXEMPT M/M - I
[/TD]
[/TR]
</tbody>[/TABLE]