VLookup with Multiple Values and Wild Card

[OAhmed]

Hi,

I am able to do VLookup with Multiple Values, but unable to solve with wild card. Example below:

SUBJ	ACCT	OBJECTIVE	Opening Balance	APR	MAY	JUN
‭351800-CAPITAL GRANTS UNAPPLIED‬	‭8300-CLGX_GG_CGUZ_SAFER & STRONGER BUILDINGS	‭999999-DEFAULT‬	-2,457.23	3,456.87	2,786.19	4,001.23
‭351800-CAPITAL GRANTS UNAPPLIED‬	‭8301-OTHR_NG_CGUZ_ST STEPHEN GARDENS	‭999999-DEFAULT‬	-62,992.00	29,872.09	37,610.40	10,982.82
‭517680-FEES AND CHARGES OTHER - NON VATABLE‬	‭8302-OTHR_GG_CGUZ_PHOTO SHOOT	‭150005-COUNTRY SHOW	-97,504.80	30,981.87	38,761.08	44,871.86
CRITERIA 1	CRITERIA 2	CRITERIA 3	VLOOKUP VALUE
351800​	8300​	999999​	2786.19​

 

[srinidhi]

The solution I can think of is to extract the numbers from the text & concatenate them,
concatenate the criteria as well,
A Single Vlookup with give you the answer.

 

[bosco_yip]

In M2, formula :

=INDEX($E$2:$G$4,INDEX(MATCH($I2&"*"&$J2&"*"&$K2&"*",$A$2:$A$4&$B$2:$B$4&$C$2:$C$4,0),0),MATCH($L2,$E$1:$G$1,0))




Regards