raviteja26187
New Member
- Joined
- Oct 28, 2015
- Messages
- 4
Hi,
I have 2 sheets as below
Sheet 1
[TABLE="width: 400"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 63"]
<tbody>[TR]
[TD="width: 63"]empid[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl68, width: 188"]dependent_name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="class: xl68, width: 153"]relation_with_self[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]dep_id[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl68, width: 63"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Kanhaiya Lal Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="width: 153"]FATHER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161532[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 400"]
<tbody>[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl68, width: 63"]empid[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl68, width: 188"]dep_name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="class: xl68, width: 153"]RELATIONDESCRIPTION[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="class: xl68, width: 183"]dependent_id[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Priya Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]WIFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161535[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Aniket Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]SON[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161534[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Chetna Srivastav[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]DAUGHTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161531[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Kanhaiya Lal Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]FATHER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161532[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Nirmala Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]SISTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161533[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to Fetch dependent_id in Sheet2 by matching Relationdescription and Empid
Can any one please help me.
Regards,
Ravimbb
I have 2 sheets as below
Sheet 1
[TABLE="width: 400"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 63"]
<tbody>[TR]
[TD="width: 63"]empid[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl68, width: 188"]dependent_name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="class: xl68, width: 153"]relation_with_self[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]dep_id[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl68, width: 63"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Kanhaiya Lal Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="width: 153"]FATHER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161532[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 400"]
<tbody>[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl68, width: 63"]empid[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl68, width: 188"]dep_name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD="class: xl68, width: 153"]RELATIONDESCRIPTION[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="class: xl68, width: 183"]dependent_id[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Priya Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]WIFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161535[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Aniket Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]SON[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161534[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Chetna Srivastav[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]DAUGHTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161531[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Kanhaiya Lal Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]FATHER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161532[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="width: 63, align: right"]40100317[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="width: 188"]Nirmala Srivastava[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 153"]
<tbody>[TR]
[TD]SISTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 183"]
<tbody>[TR]
[TD="width: 183"]161533[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would like to Fetch dependent_id in Sheet2 by matching Relationdescription and Empid
Can any one please help me.
Regards,
Ravimbb