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
<tbody>
</tbody>
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
A | B | C | D | E | F | G |
ASSETS | ||||||
Current Assets | ||||||
Checking/Savings | ||||||
102-00C · WASHINGTON FEDERAL - C | ||||||
102-00E · WASHINGTON FEDERAL - E | ||||||
102-00H · WASHINGTON FEDERAL - H | ||||||
102-00I · WASHINGTON FEDERAL - I | ||||||
103-00E · VANGUARD TAX EXEMPT M/M - E | ||||||
103-00H · CASH - VANGUARD TAX EXMPT M/M | ||||||
103-00I · VANGUARD TAX EXEMPT M/M - I |
<tbody>
</tbody>