Actualy i am having two sheets one as Master having 3 fields as Doc Id, Tags1,S.No
whereas my second sheet having only two fields as Doc Id ,Tags2
I want to compare Tags1 (Master Sheet) with Tags2 (Answer Sheet)....Problem is that here primary key is Doc Id as exists in both the sheets .But i want to make S.No as Primary key....S.No exist in my Master sheet but not in Answer sheet....i want somehow to call S.No in answer sheet...Your mentioned solution is not working as already
Tags2 are coming from my Answer sheet.
If i use
RowNo() AS S.No
Than inside script two times From will exist...which is wrong ....Please help me if u have any other solution...