Please Somebody help me to solve this.

[Shafique]

 

[Fluff]

You cannot post images from your desktop.
Please explain in words what you have & what you want.

 

[Shafique]

[TABLE="width: 578"]
<colgroup><col><col><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]TABLE 1[/TD]
[TD][/TD]
[TD="colspan: 2, align: left"]Answer Sheet[/TD]
[TD="align: left"]Answer[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD][/TD]
[TD="align: left"]Criteria 1[/TD]
[TD]22-Nov[/TD]
[TD="align: left"]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Sr[/TD]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]City[/TD]
[TD]Quantity[/TD]
[TD][/TD]
[TD="align: left"]Criteria 2[/TD]
[TD]2[/TD]
[TD="align: left"]sr[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]22-Nov[/TD]
[TD]ABC[/TD]
[TD]CA[/TD]
[TD]150[/TD]
[TD][/TD]
[TD="align: left"]Name[/TD]
[TD="align: left"]

?

<tbody>
</tbody>

[/TD]
[TD="align: left"]DEF[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]22-Nov[/TD]
[TD]DEF[/TD]
[TD]JS[/TD]
[TD]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]22-Nov[/TD]
[TD]GHI[/TD]
[TD]FS[/TD]
[TD]850[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1[/TD]
[TD]23-Nov[/TD]
[TD]JKL[/TD]
[TD]PK[/TD]
[TD]451[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2[/TD]
[TD]23-Nov[/TD]
[TD]MNO[/TD]
[TD]OR[/TD]
[TD]680[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]3[/TD]
[TD]23-Nov[/TD]
[TD]PQR[/TD]
[TD]BD[/TD]
[TD]554[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1[/TD]
[TD]24-Nov[/TD]
[TD]STU[/TD]
[TD]SP[/TD]
[TD]628[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2[/TD]
[TD]24-Nov[/TD]
[TD]VWX[/TD]
[TD]HW[/TD]
[TD]479[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]24-Nov[/TD]
[TD]YZ[/TD]
[TD]LK[/TD]
[TD]570[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Shafique]

please discribe it how to get name within date and Sr's given criteria. in simple words i want get name in sepecific date also looks its sr value.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	Sr	Date	Name	City	Quantity		Criteria 1	22-Nov
2	1	22-Nov	ABC	CA	150		Criteria 2	2
3	2	22-Nov	DEF	JS	250		Name	DEF
4	3	22-Nov	GHI	FS	850
5	1	23-Nov	JKL	PK	451
6	2	23-Nov	MNO	OR	680
7	3	23-Nov	PQR	BD	554
8	1	24-Nov	STU	SP	628
9	2	24-Nov	VWX	HW	479
10	3	24-Nov	YZ	LK	570
Sheet2

Cell Formulas
Range	Formula
H3	{=INDEX(C2:C10,MATCH(1,(B2:B10=H1)*(A2:A10=H2),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Shafique]

How about

Excel 2013/2016

	A	B	C	D	E	F	G	H
Sr	Date	Name	City	Quantity	Criteria 1
ABC	CA	Criteria 2
DEF	JS	Name	DEF
GHI	FS
JKL	PK
MNO	OR
PQR	BD
STU	SP
VWX	HW
YZ	LK

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: right"]22-Nov[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]22-Nov[/TD]

[TD="align: right"]150[/TD]
[TD="align: right"][/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]22-Nov[/TD]

[TD="align: right"]250[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]22-Nov[/TD]

[TD="align: right"]850[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]23-Nov[/TD]

[TD="align: right"]451[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]23-Nov[/TD]

[TD="align: right"]680[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]23-Nov[/TD]

[TD="align: right"]554[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24-Nov[/TD]

[TD="align: right"]628[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]24-Nov[/TD]

[TD="align: right"]479[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]24-Nov[/TD]

[TD="align: right"]570[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H3[/TH]
[TD="align: left"]{=INDEX(C2:C10,MATCH(1,(B2:B10=H1)*(A2:A10=H2),0))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

Thanks For Helping me. Your are a pretty Genius man of part.