I have data in Excel file to combine table 2 sheets (Have data with web : https://www.contextures.com/xlSampleData01.html)
How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new table 1 sheet (Use VLOOKUP formula with multiple condition) without PivotTable ?
Image to describe How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new table 1 sheet : https://i.stack.imgur.com/3b1Ol.png
Because I learn with web https://www.ablebits.com/office-addins-blog/2020/02/12/vlookup-multiple-sheets-excel-examples/ and https://trumpexcel.com/vlookup-with-multiple-criteria/ and try to use VLOOKUP formula with single condition with example =VLOOKUP(A2, 'ข้อมูลตัวอย่าง2-1'!$A$2:$D$4, 4, FALSE) to display at ข้อมูลรูปแบบรวมเป็นตารางเดียว2 Sheet (Yellow sheet tab) and can use VLOOKUP formula with single condition normally but try to use VLOOKUP formula with multiple condition with example =VLOOKUP(A2&B2&C2, ข้อมูลตัวอย่าง2!$A$2:$D$41, 4, FALSE) to display at ข้อมูลรูปแบบรวมเป็นตารางเดียว3 Sheet (Orange sheet tab) to cannot use VLOOKUP formula with multiple condition normally (have #N/A value instead VLOOKUP value) with image link : https://i.stack.imgur.com/uji6M.png
Example excel file with Link : https://github.com/doanga2007/doanga2007.github.io/raw/master/CombineTable2Sheet2.xlsx