Need to retrieve multiple records from data, based on multiple criteria

Hello All,

I've been stumped on this problem for months and could use a helping hand.

Hopefully I can explain this well enough - it's a very unique situation I believe.


I have a spreadsheet tab that is linked to a database in Access (so it is ever changing when the database is updated). The number on columns will not change, but the number or rows will, this makes it difficult to pinpoint a formula. I cannot change the wording of anything on the first tab (that is linked to the Database), but I can change the order of the columns if needed to make a formula work.
There are a number of clients listed, and for multiple years.

What I am trying to achieve is to pull in information (from a number of different columns) to a separate tab, based on two criteria the client code (LNAMES) AND the year (YEAREND).


I have been back and forth with INDEX/MATCH formulas, and LOOKUPS, but can't seem to get any of them to work for what I need.
I did have success with the DGET formula, but only for the first entry (as seen on the second tab of my attached example).
Does anyone know of a way to effectively drag that formula down to all the rest without error?
Or even, a different formula that I could use for the multiple criteria?



Any and all help would be much appreciated.

Thanks!
Ashley

In C2, enter this formula with Ctrl + Shift + Enter keys together since it is an array formula. Then drag the formula down and across

=INDEX('Linked to Database in Access'!C$2:C$13,MATCH($A2&$B2,'Linked to Database in Access'!$A$2:$A$13&'Linked to Database in Access'!$B$2:$B$13,0))

You can just put an IF condition.

=IF(INDEX('Linked to Database in Access'!C$2:C$13,MATCH($A2&$B2,'Linked to Database in Access'!$A$2:$A$13&'Linked to Database in Access'!$B$2:$B$13,0))<>0,INDEX('Linked to Database in Access'!C$2:C$13,MATCH($A2&$B2,'Linked to Database in Access'!$A$2:$A$13&'Linked to Database in Access'!$B$2:$B$13,0)),"")