How to enter Index / Match formula in Access
Example in Excel is listed below
=IFERROR(INDEX(DESCRIP!$F:$F,MATCH($AA:$AA,DESCRIP !$C:$C,0)),"")
How to enter Index / Match formula in Access
Example in Excel is listed below
=IFERROR(INDEX(DESCRIP!$F:$F,MATCH($AA:$AA,DESCRIP !$C:$C,0)),"")
You create a query displaying the fields from the tables you require the information from. You would join the tables in the query on the fields that you require to be matched.
I will try and let you inform results