Lookup Data from one Excel to Another

[Jitendra.Kumar]

Refer this post.

Comapring multiple coulmns in Excel Files

Hi All, I have two Excel files Excel1: [image] Excel2: [image] I need to compare first two columns in both the sheets and if matched, update the third column in first sheet taking value from second sheet 3rd column. Also I want to validate if a cell in 1st sheet is empty then write a exception. Please help me friends. I have gone through many topics but can’t find the exact solution.

If you will not be sure after going thorough it. illustrate data from your excel files. I will try to write formula for you.