The title pretty much says it. The formula I'm trying to use is:
=INDEX('Bank Statements'!$A$4:$D$750,MATCH(1,INDEX(('Bank Statements'!$A$4:$A$750=F5)*('Bank Statements'!$B$4:$B$750="*GIRO*"),),FALSE)) as an array.
Bank Statements row A is a list of Dates
Bank Statements row B is a list of transactions some of which will include the letters GIRO
Bank Statements row D is a list of Currency Values
F5 refers to a date cell in the worksheet I am entering the formula into
I am trying to return the currency value in Bank Statements row D
I sure thought I had this one figured out but I cannot get any information to return.
Any help is appreciated.
=INDEX('Bank Statements'!$A$4:$D$750,MATCH(1,INDEX(('Bank Statements'!$A$4:$A$750=F5)*('Bank Statements'!$B$4:$B$750="*GIRO*"),),FALSE)) as an array.
Bank Statements row A is a list of Dates
Bank Statements row B is a list of transactions some of which will include the letters GIRO
Bank Statements row D is a list of Currency Values
F5 refers to a date cell in the worksheet I am entering the formula into
I am trying to return the currency value in Bank Statements row D
I sure thought I had this one figured out but I cannot get any information to return.
Any help is appreciated.