Hi,
I'm looking for the expression to look up a price from another table that matches the product in the form that would be a REF in the same table.
Thanks,
Brendan
It's hard to provide confident guidance without more information regarding your tables and columns, but here are a couple potential approaches.
[Product ID].[Price]
INDEX(SELECT(Products[Price], [Product ID] = [_THISROW].[Product ID]), 1)
Thanks for the quick response.
Table 1: Bottle Inventory_Powerhouse Ibiza (Source)
Table2: Bottle Sales
REF: Bottle ID to Bottle Type
Select goal : Price Per Unit (Bottle Inventory_Powerhouse Ibiza) -- > Cost (Bottle Sales )
The goal is to carry the price that matches the bottle type from the database into the sales form.
I just tried it with your formula! it worked great thank you so much!
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |