How to use the Index Function with names instead of cell positions as headers

[DownUnderFar]

How do I use the index function when my rows and columns are identified by name rather than position:

For example: How do I enter the data of the cell for KSA, 154? Index(A1:C8, "KSA", "154")

A1	B1 154	C1 132
A2 HNL	7:30 AM	7:30 AM
A3 MAJ	10:35 AM - 11:20 AM	10:35 AM - 11:40 AM
A4 KWA	12:20 PM - 12:59 PM	N/A
A5 KSA	1:15 PM - 1:47 PM	N/A
A6 PNI	2:52 PM - 3:20 PM	1:15 PM - 2:05 PM
A7 TKK	3:40 PM - 4:20 PM	2:25 PM - 3:30 PM
A8 GUM	6:00 PM	5:10 PM

 

[kevin9999]

You could use an Index/Match/Match

Book1
	A	B	C
1	A1	B1 154	C1 132
2	A2 HNL	7:30 AM	7:30 AM
3	A3 MAJ	10:35 AM - 11:20 AM	10:35 AM - 11:40 AM
4	A4 KWA	12:20 PM - 12:59 PM	N/A
5	A5 KSA	1:15 PM - 1:47 PM	N/A
6	A6 PNI	2:52 PM - 3:20 PM	1:15 PM - 2:05 PM
7	A7 TKK	3:40 PM - 4:20 PM	2:25 PM - 3:30 PM
8	A8 GUM	6:00 PM	5:10 PM
9
10
11		1:15 PM - 1:47 PM
Sheet1

Cell Formulas
Range	Formula
B11	B11	=INDEX($A$1:$C$8,MATCH("* KSA",$A$1:$A$8,0),MATCH("* 154",A1:C1,0))

 

[Peter_SSs]

I think that sample data includes cell addresses so it may be ..

23 07 03.xlsm
	A	B	C
1		154	132
2	HNL	7:30 AM	7:30 AM
3	MAJ	10:35 AM - 11:20 AM	10:35 AM - 11:40 AM
4	KWA	12:20 PM - 12:59 PM	N/A
5	KSA	1:15 PM - 1:47 PM	N/A
6	PNI	2:52 PM - 3:20 PM	1:15 PM - 2:05 PM
7	TKK	3:40 PM - 4:20 PM	2:25 PM - 3:30 PM
8	GUM	6:00 PM	5:10 PM
9
10
11		1:15 PM - 1:47 PM
INDEX

Cell Formulas
Range	Formula
B11	B11	=INDEX($A$1:$C$8,MATCH("KSA",$A$1:$A$8,0),MATCH(154,A1:C1,0))

 

[kevin9999]

I think that sample data includes cell addresses so it may be ..

I see, said the blind man, as he picked up his wooden leg and saw
Well spotted Peter