I am using INDEX MATCH MATCH combined with another INDEX to return a rate from another tab. Column A is date, column B is the description, and column G is the rate. My current formula is INDEX('SHEET1'!$G$4:$G$50000,MATCH(1,INDEX(('SHEET1'!$A$4:$A$50000=A5)*('SHEET1'!$B$4:$B$50000="INVESTMENT FUNDS WEEK 1"),0,1),0)) Basically i would like to replace the 1 in "investment funds week 1" with a wild card. is this possible?
Solved by M. Q. in 15 mins