Return data from Array, intersection of Row and Column

[ayotte]

Newbee here

I have an array that I'd like to return the data from using the row and colunm names. I've searched and the results I get do not work. We do not have the developer tab, so will not use VBA, would like to use cell formulas.

I've setup the array as GEO_ARRAY, row names as variable SLOT_MAT, and the Columns as variable GEO_MAT.
what I'd like to do is somehting link this
=GEO_ARRAY[[XA3],[GA4]] to return the contents, but it returns a formula error. I've tried many different combos, still no workie, I'm miffed...

GAP GA4 GA3 GA2 GA1 GA0
XA1 NC NC NC NC NC GND
XA2 NC NC NC NC GND NC
XA3 GND NC NC NC GND GND
XA4 NC NC NC GND NC NC
XA5 GND NC NC GND NC GND
XA6 GND NC NC GND GND NC
XA7 NC NC NC GND GND GND
XA8 NC NC GND NC NC NC
XA9 GND NC GND NC NC GND
XA10 GND NC GND NC GND NC
XA11 NC NC GND NC GND GND
XA12 GND NC GND GND NC NC
XA13 NC NC GND GND NC NC
XA14 NC NC GND GND GND NC
XA15 GND NC GND GND GND GND
XA16 NC GND NC NC NC NC
XA17 GND GND NC NC NC GND
XA18 GND GND NC NC GND NC
XA19 NC GND NC NC GND GND
XA20 GND GND NC GND NC NC
XA21 NC GND NC GND NC GND

[zbor]

Try INDEX/MATCH combination of formula:

[JosephP]

We do not have the developer tab, so will not use VBA, would like to use cell formulas.

you mean it has been disabled in a group policy, or you just haven't chosen to show it on the ribbon?