Joins between two sheets in Excel

Help Studio
, ,
1

Hi I’m facing an issue when i tried to join two sheets into another sheet.
Sheet1:
image

sheet2:
image

Expected Output:

image
image700×210 5.65 KB

when I tried using left join it is giving duplicate values.
Actual:

image
image895×191 26.1 KB

could someone help me with this?Compare Excel sheets.xlsx (15.2 KB)

2

Hi
Did we try with other JOIN methods
@Vishwanth_Raya

3

Try Inner Join

4

Yes, i have tried using other joins, but still unable to get the expected result.

5

Yes, i have tried using inner join too, but still didn’t get the expected result.

6

@Vishwanth_Raya… Learn remaining joins which one suits u that u seeking for… Kindly check given below
Story line of Join Data Table

1 Like