Lookup not retrieving the exact phrase for the row

[Amitai_Hirshman]

Hi
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:
lookup([sku],inventory,sku,weight)

[Lynn · Accepted solution]

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

help.appsheet.com

SUM()

Arithmetic sum of list items

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Amitai_Hirshman]

Thanks!

[Marc_Dillon]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

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

[Amitai_Hirshman]

perfect, Thanks!