Forum Discussion
Lookup with multiple criteria between 2 sheets
I have two sheets Sales <tblSales> Inventory<tblInventory> In sheet inventory I have14 columns data. But I am interested in column Code. It is auto generated. Like WT-B-1 for same...
I'm currently unable to directly access external links or files. However, I try to guide you on how to implement the formula in your provided scenario.
If you are using Excel Web and Android mobiles, and the CHOOSECOLS function is not supported, you can try using a combination of INDEX, MATCH, and FILTER functions.
Assuming your Sales table starts from cell A1 in the Sales sheet, and your Inventory table starts from cell A1 in the Inventory sheet, you can use a formula similar to the following:
=IFERROR(INDEX(tblInventory[Code], MATCH(1, (tblInventory[Product]=B2)*(tblInventory[Name]=B3)*(tblInventory[Quantity]>0), 0)), "")
Remember to replace tblInventory with the actual table name in your Inventory sheet.
Sir, I sent link so you can see the actual problem easily. B2 and b3 you mentiond in vertical but it is b2 and c3, which is horizantal. With xlook or sumproduct. I reach codes but here i dont get codes for current stock if previous stock ends. As was the problem from very beginning of this.
Thanks
