I am fairly new to coda and I’ve been struggling to use the lookup formula and was trying to seek some help.
So have a table A and a table B
I need to pull data from table A column 5 to table B column 2 and the matching reference should be the unique values of each column.
SO Table A has products listed in its first column and column 5 has prices
Table B also has products listed in its first column and column 2 should pull data from TableA.Column5
Now Table B already reference Table C (which is the master source of products list), so I am unable to just click + sign in the tables and add the column as it only allows me to add columns from Table C.
I’ve tried the lookup formula but wasn’t able to do it. Please help.