-1

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

4
  • 1
    Convert Sheet name in English!! Oct 18, 2020 at 6:18
  • @RajeshS I convert sheet name in English and post answer to combine table 2 sheets to new table 1 sheet with formula. Oct 18, 2020 at 6:49
  • That's good,, please remove the LINK from LAST Comments, since you have used the same PAGE/QUESTION link you are working with !! Oct 18, 2020 at 7:30
  • @RajeshS OK , I remove the link from last comment already. Oct 18, 2020 at 8:17

1 Answer 1

0

Good News : I fix problem with solution and credit to fix problem : https://www.snasui.com/viewtopic.php?f=3&t=17680

  1. Use formula in example E2 =INDEX(Sampledata2!D$2:D$41,MATCH(1,INDEX((Sampledata2!A$2:A$41=A2)(Sampledata2!B$2:B$41=B2)(Sampledata2!C$2:C$41=C2),),))

Image link to describe use formula in example E2 because you need at least 10 reputation to post images : https://i.stack.imgur.com/coJFT.png

  1. I can to combine table 2 sheets to new table 1 sheet with formula.

Excel file to fix problem link with Sheet name in English : https://github.com/doanga2007/doanga2007.github.io/raw/master/CombineTable2Sheet3.xlsx

4
  • 1
    Share some sample Screen shot,, will help you to justify the method you have used so far, will attract readers and you may get UP votes too ☺ Oct 18, 2020 at 7:32
  • @RajeshS I add image link to describe use formula in example E2 already. Oct 18, 2020 at 11:25
  • I don't think the facebook-link is helpful.
    – Mast
    Oct 18, 2020 at 12:36
  • 1
    @Mast I delete facebook-link and remain credit to fix problem 1 link to helpful. Oct 18, 2020 at 12:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .