Find value based on criteria and partial text

[Villalobos]

Hello,

I would like to ask some help regarding that how to find a value based on criteria and partial text. There is one condition: the different partial texts should be managed inside the formula (not store in range).

I have atteched a sample file with the desired results.

Thank you in advance the answer!

 

[bosco_yip]

Try,

G6, copy down :

=IFERROR(LOOKUP(2,1/((B$6:B$28=E6)*MMULT(ISNUMBER(FIND({"TU0","KOMPRES","BO0"},C$6:C$28))+0,{1;1;1})),C$6:C$28),"")

Regards
Bosco

 

[Villalobos]

Hi,

I have tested but the formula doesn't working for me.

 

[bosco_yip]

Hi,

I have tested but the formula doesn't working for me.

See attached file, I put formula in F6……

Regards
Bosco

 

[Villalobos]

Hi,

Great, thank you!