Lookup not retrieving the exact phrase for the row

I have an ‘orders’ table with SKU column, and an ‘inventory’ table with a matching SKU column and a weight column. I built a virtual column in the ‘orders’ table and trying to retireve the correct weight for each order using the lookup expression, in excel I would use vlookup.
it is retriveing the first wieght in the table for all the rows and not the correct answer for each SKU
What am I doing wrong?
this is my formula:

Hi @Amitai_Hirshman
Check out SUM(SELECT… You will find lots of examples if you search the forum or

1 Like

Read the “Troubleshooting” section in the bottom half of this article. That should explain to you exactly what to change and why.



perfect, Thanks!