Reference a value in one column then to get a same-row value in a different column?

[sinpeople]

Hi folks,

Thank you guys for your support.
I have a table below. I need to find out a value "ONGZ7 C4.15" in the 2nd column, then to find out the same-row value in the 2nd last column, which is "1065".

Suppose the key "ONGZ7 C4.15" is a cell value in a different workbook, how should I do it?

Best Regards
David

Account	Symbol	Net Pos	$ Open P/L	$ Options Value	Expiration Date	$ Initial Margin	$ Maintenance Margin	DTE
E76912	OCLX7 C57.5	-2	120	-40	10/17/17	1428	1298	15
E76912	OCLZ7 C59	-5	400	-500	11/15/17	3311	3010	44
E76912	OCLZ7 C61	5	-350	250	11/15/17	0	0	44
E76912	OCLF8 C62.5	-5	450	-600	12/14/17	2354	2140	73
E76912	OCLF8 C64.5	5	-400	300	12/14/17	0	0	73
E76912	OGCX7 C1440	-1	180	-30	10/26/17	713	648	24
E76912	OGCZ7 C1500	-5	1200	-200	11/27/17	2453	2230	56
E76912	OGCZ7 C1525	5	-1000	100	11/27/17	0	0	56
E76912	ONGX7 C3.75	-5	550	-100	10/26/17	1062	965	24
E76912	ONGX7 C3.95	5	-300	50	10/26/17	0	0	24
E76912	ONGZ7 C4.15	-5	600	-350	11/27/17	1172	1065	56
E76912	ONGZ7 C4.35	5	-450	150	11/27/17	0	0	56
E76912	OZCH8 C4.8	-2	376.25	-62.5	02/23/18	134	122	144
E76912	OZSX7 C11.6	-2	925	-25	10/27/17	244	222	25
E76912	OZSH8 C13	-2	-300	-300	02/23/18	339	308	144

<tbody>
</tbody>

 

[Cross Terrier]

Hi folks,

Thank you guys for your support.
I have a table below. I need to find out a value "ONGZ7 C4.15" in the 2nd column, then to find out the same-row value in the 2nd last column, which is "1065".

Suppose the key "ONGZ7 C4.15" is a cell value in a different workbook, how should I do it?

=INDEX($A$1:$I$15,MATCH("ONGZ7 C4.15",$B$1:$B15,0),8,0)

Select the entire table for the area in your index, then use the MATCH formula to find the row with the key on. This needn't be the entire thing in quotes, as I used, it can be a reference to a cell anywhere else. Use 8 to show that it is the result in the eighth column in the index area and 0 to show that you need an exact match. This formula will bring the entry in the eighth column on the same row as the key.