Two way lookup with if/match return

[sanrama]

Hi All,

Need help, I am struggling to find the solution. Below is my details,

		A	B	C	D	E	F	G	H	I	J
1		Name	Date	1	2	3	4	5	6	7	8
2		Day	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri
3		Mr. A	B	B	B	A	A	O	B	A
4		Mr. B	A	A	O	B	B	L	O	B
5		Mr. C	L	O	L	L	L	B	A	A
6		Mr. D	G	B	O	G	G	L	G	G
7		Mr. E	G	G	A	O	G	L	G	G

Case 1
Lookup 1	2	Date ( in raw 1 )
Lookup 2	B	Column F ( Lookup 1 matching column, in this case it matching column array is G3:G7 )
Result 1	Mr. A
Result 2	Mr. D
Result 3
Result 4

Case 2
Lookup 1	6	Date ( in raw 1 )
Lookup 2	L	Column F ( Lookup 1 matching column, in this case it matching column array is K3:K7 )
Result 1	Mr. B
Result 2	Mr. D
Result 3	Mr. E
Result 4

Thanks in advance

 

[Fluff]

My pleasure.