Look up stock formula
M
please
look into my file
need formula on e2 drag down to find stocks by location from data column a and b
See my file manually done
Hello and welcome to the forum,
Which version of Excel are you using? 2016/2021/365... ?
Then your table is very unclear to me, how are we supposed to know which shops are under location 10PK738?
Are you looking for a simple sum by shop name, aka https://excel-pratique.com/en/functions/sumif, or a more complex analysis?
D
Hi MAK TZ,
Since your version of Excel is "The latest," I assume it's 365... Here's a formula
=IF(D2<>"";XLOOKUP(D2;$A$1:$A$34;B1:B34;"Not found";0;1);"")to put in cell E2 and drag down from E2 to E7.
That should do the trick!
DanD