Access formula equivalent to index, match in excel

[CUCKOO]

PRODUCT	VALUE A	VALUE B
WW	10	100
XX	20	200
YY	30	300
ZZ	40	400

I have above table in access. I want to use this table in query to find value of any product using a formula (Value A*X)+Value B. The product and X query picks up from another table. The same can be done easily in Excel using Index, Match formula but how in Access.

[alansidman]

You will need to build a query joining the two tables and then doing a simple calculation in the query. Here is a SQL statement for that

SELECT Table1.product, ([ValueA]*[ValueX])+[ValueB] AS Expr
FROM Table1 INNER JOIN Table2 ON Table1.product = Table2.Product;