Forum Discussion
How many actually sales
Hi, I have to find the formula to put in actually sales in my tabel wich shows what I put in order. I have a tabel wich shows exactly what I sat in ordrer with GTIN and cuantum, and I also hav...
These formulas are very version dependent. One has been able to use Tables to reference data from 2007 but it is only recently that XLOOKUP has replaced VLOOKUP.
"Within orders table"
= XLOOKUP([@GTIN], Sales[GTIN], Sales[Sold], 0)
"As an array formula used outside any table"
= XLOOKUP(orders[GTIN], Sales[GTIN], Sales[Sold], 0)If you are using legacy versions of Excel the VLOOKUP solution posted by NikolinoDE is all you have available to you. I would still recommend the use of Tables and Structured References though.