Index Match using 2 critereria with one being a text wildcard all located on a different worksheet

[neostand]

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.

 

[NBVC]

The Wildcard doesn't work when using the = to compare...

Try:

=INDEX('Bank Statements'!$A$4:$D$750,MATCH(1,INDEX(('Bank Statements'!$A$4:$A$750=F5)*(ISNUMBER(FIND("GIRO",'Bank Statements'!$B$4:$B$750))),),FALSE))

 

[neostand]

Thanks,
That got me a #Ref error on the correct match so that is a start.
I think I may be approacing my second criteria incorrectly

Let me try to reword it.

If F5 matches a date in Column A and cell B in the same row also contains the letters GIRO then I want to return the value of cell D in the same row

Sort of like a Vlookup but that also checkes for GIRO in the adjacent cell before returning a True/False

I hope that makes sense.

 

[NBVC]

The Ref error is because you are missing the Column Num part in the INDEX function. What column in A:D are you trying to extract? that is the number to put in the red part below

=INDEX('Bank Statements'!$A$4:$D$750,MATCH(1,INDEX(('Bank Statements'!$A$4:$A$750=F5)*(ISNUMBER(FIND("GIRO",'Bank Statements'!$B$4:$B$750))),),FALSE),COLUMN_NUM)

Looks like you need column 4... so

=INDEX('Bank Statements'!$A$4:$D$750,MATCH(1,INDEX(('Bank Statements'!$A$4:$A$750=F5)*(ISNUMBER(FIND("GIRO",'Bank Statements'!$B$4:$B$750))),),FALSE),4)

 

[neostand]

BINGO!
Thanks NBVC!