How I can compare value number in 2 table Appsheet

[giahuylpu]

Item's Price

A	B	C
1.000	2.000	5.000

DATA

Date	Name	Item	Price
1-May	John	A	1.000
2-May	Mike	A	1.500

I want compare Column Price (DATA) vs Item's Price with Format Rule in Appsheet.

I search some function but I cant find the solution.

Thanks for help! 

[Aurelien]

Hi @giahuylpu 

You will need to use dereference expression.

For reference: Dereference expressions - AppSheet Help

Also, you will need to change the structure of your Item's price table.

I would suggest having the table of ITEMs made this way:

ITEM ID	Description	Price
A	product A	1000
B	product B	2000
C	product C	5000

The table DATA must have the column [Item] set with type Ref, source table ITEM.

Then, you will be able to user this if you wish to know if it's the same in your table DATA and your table ITEM:

[Price]=[Item].[Price]