Vlook up

[KIM Chanthan]

Dear Sir,

I want to use vlook up to look up look up value with table array, but this 2 things are not 100% the same.
Please view attached file for more detail.

Thank for your support,
Chanthan

 

[Nebu]

Hi:

May be something like this?

Thanks

 

[Vishal Srivastava]

Dear Sir,

I want to use vlook up to look up look up value with table array, but this 2 things are not 100% the same.
Please view attached file for more detail.

Thank for your support,
Chanthan

Try this one:

=IFNA(LOOKUP(1,1/SEARCH(F3,$A$3:$A$8),$B$3:$B$8),LOOKUP(1,1/SEARCH(A3,$F$3:$F$8),$B$3:$B$8))