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)
Solved! Go to Solution.
Hi @Amitai_Hirshman
Check out SUM(SELECTโฆ You will find lots of examples if you search the forum or
Hi @Amitai_Hirshman
Check out SUM(SELECTโฆ You will find lots of examples if you search the forum or
Thanks!
Read the โTroubleshootingโ section in the bottom half of this article. That should explain to you exactly what to change and why.
perfect, Thanks!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |