Hello
My question is. I have a sheet lets say Called "Inventory" there I have 10,000 items with information from UPC, Name, Cost, etc.
i don't want to use the sort for specific items so I created another sheet which I'll call "toilet paper" I want that this sheet should search in sheet "Inventory" everything we have from "toilet paper' and bring me a list of how many listings we have with this keyword and all the information there is as UPC, Name, Cost, etc.
I tried v lookup like
A B
*toilet paper* =VLOOKUP($A$1,Inventory!$A$2:$N$18952,14,FALSE)
and i tried some more but can't get anything. any better way?
Thanks
My question is. I have a sheet lets say Called "Inventory" there I have 10,000 items with information from UPC, Name, Cost, etc.
i don't want to use the sort for specific items so I created another sheet which I'll call "toilet paper" I want that this sheet should search in sheet "Inventory" everything we have from "toilet paper' and bring me a list of how many listings we have with this keyword and all the information there is as UPC, Name, Cost, etc.
I tried v lookup like
A B
*toilet paper* =VLOOKUP($A$1,Inventory!$A$2:$N$18952,14,FALSE)
and i tried some more but can't get anything. any better way?
Thanks
