Excel has an Index function explained below is there a way to do the same function in Access?
Returns a value or the reference to a value from within a table or range. There are two forms of the INDEX() function: array and reference. The array form always returns a value or an array of values...
I apologize if I posted this in the wrong section
I have a Matrix in Excel example below that includes a top row % labeled M and a first Column % labeled P. What I am trying to do is from Access go to this Excel Matrix and import a specific value or sets of values. For example if M% is 106% and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.