two dimensional array lookup

[BE19]

I have a two dimensional array. Let's call the column header PaxFwd and the row header PaxAft. Both headers contain numbers (not that this matters). I need to be able to cross reference the row selection with the column selection (it doesn't matter which is selected first) and return the value at the union of the column and row.

I've looked at nested combo boxes but that doesn't seem to fit because the row and column choices are independent of each other.

Please no VBA or limited (very!) SQL. This is *not* what I do for a living.

One way I have thought about doing it seems kludgy and that is to create tables of each column...

TIA

 

[Dennisk]

this has to be in VBA as how else have you created your array?

 

[BE19]

All I've done at this point is to create a table with the values. The only solution I saw was to rename the field names to the necessary column names then use the row that had the values as a primary key. Stopped after that because I wasn't sure how to proceed.

 

[Dennisk]

to do that you require a unique key for each row, then select the column.

here is an example

SELECT myColumn FROM myTable WHERE [mytablePrimaryKey] =" & myKeytoFind

just substitute your table ,column and primarykey names