• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inner Join in MS Excel

J

jskushawah

New Member
I have two tables of same data of Aug and July, i want to apply a function which give me the result like inner join in SQL.

is it possible through a function? if yes what is that function?


regards

Jitendra
 
Hi, jskushhawah!

Use the built-in search feature at top right of this window and look for vijaySharma posts, if I don't remember wrongly he'd wrote something about it.

Regards!
 
Hi Jitendra ,


In case you are not familiar with the INNER JOIN , please go through this link :


http://www.w3schools.com/sql/sql_join_inner.asp


From the example given there , you can see that the method to get an INNER JOIN in Excel is to use the VLOOKUP function , as long as there are no duplicates in either table.


If there are duplicates in only one table , and the inner join is from that table , then you can use the technique explained in this earlier question :


http://chandoo.org/forums/topic/vlookup-2nd-instance


Use the formulae along with the table which does not have duplicates , and retrieve the multiple values from the second table.


Narayan
 
You must log in or register to reply here.
Back
Top