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...