Index / Match function in Access

[aslamnoori]

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)),"")

[alansidman]

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.

[aslamnoori]

I will try and let you inform results