Fill up a column based on some difficult criterias

[hsandeep]

My data is like:

	LH	LI	LJ	LK	LL	LM	LN	LO	LP	LQ
50	Table 1	Table2	Table 3	B
53	281.60	284.75	285.00	290.75	A	B	C	D	200	284.75
54	307.30	311.35	312.00	312.90	A	B	C	D	100
55	307.30	311.35	312.00	312.90	A	D	C	B	200	312.90
56	156.30	158.35	158.80	163.20	A	B	C	D	100
57	0.00	0.00	0.00	0.00					100
58	0.00	0.00	0.00	0.00					100
59	295.65	301.55	303.35	312.50	B	A	C	D	200	295.65
60	166.20	169.00	169.30	176.35	A	B	C	D	100
61	201.20	205.60	206.00	214.60	D	B	A	C	100
62	579.60	579.60	581.90	587.55	C	A	D	B	200	587.55

<tbody>
</tbody>

Requirement: Table 3 LP53:LP62 needs to be filled with values of Table 1
Criteria:
(1) MATCH LQ50 with Table 2 & pull corresponding cell position from Table 1
(2) IF Corresponding cell address of LP53:LP62 contains 200 then LQ53:LQ62=Table 1

Example:
LQ50=B
Table 2: B is in LM53 which is 2nd column of Table 2. So get 2nd column from Table 1 i.e. LI53 (284.85)
LP53=200 so LQ53=284.75

Similarly, LQ54:LQ62 needs to be filled.
Formula required for LQ53:LQ62
How to accomplish?

 

[Takae]

If Table3 is not 200,column LQ is blank.
Hope this helps.
LQ53=IF(LP53=200,INDEX($LH53:$LK53,1,MATCH($LR$50,$LL53:$LO53,0)),"")

 

[hsandeep]

If Table3 is not 200,column LQ is blank.
Hope this helps.
LQ53=IF(LP53=200,INDEX($LH53:$LK53,1,MATCH($LR$50,$LL53:$LO53,0)),"")

It WORKS. Thanks Takae. I changed $LR$50 to $LQ$50