I hope I posted this question in the right forum this time.
I am newbie here and is having hard time in doing this.
I have an excel workbook which has two sheets Grp1 and Grp2
within these sheets i have unit and id columns, what I am trying to do is find out the combination of unit and id column which is on Grp1 but not on Grp2 tab.
Can I use the Lookup function for this.Could you all please help?