DownUnderFar
New Member
- Joined
- Jul 4, 2022
- Messages
- 16
- Office Version
- 365
- Platform
- MacOS
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")
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 |