K KIM Chanthan Member Apr 11, 2016 #1 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 Attachments Vlook up.xlsx Vlook up.xlsx 10.9 KB · Views: 9
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
N Nebu Excel Ninja Apr 11, 2016 #2 Hi: May be something like this? Thanks Attachments Vlook up.xlsx Vlook up.xlsx 11.3 KB · Views: 8
V Vishal Srivastava Member Apr 11, 2016 #3 KIM Chanthan said: 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 Click to expand... 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))
KIM Chanthan said: 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 Click to expand... 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))