Grocery List Error

[Mchllwoods]

I posted this problem a couple months before and I thought I had it figured out but now I have a new problem. I recently upgraded my computer to Windows 10 so now I have Microsoft Office 365. In my wishlist sheet some of my items are blank when I know I have them listed in my stores sheet. For some reason, Excel can't find it. I've reworded some items but still no luck. I even made the department column in wishlist sheet text and eliminate extra items I don't need in stores sheet to ensure it would be found through the aggregate function but still...

Can someone please tell me what I'm doing wrong? Thanks!!!

https://www.dropbox.com/s/8pl3xfu4p84swok/MyGroceryList.xlsx?dl=0
https://d.docs.live.net/9113a0b1788d6431/Personal Finance/MyGroceryList.xlsx

 

[Peter_SSs]

Try adding these 2 extra sets of parentheses
=IF(AGGREGATE(15,6,(ROW(st_items)-ROW(tbl_stores[#Headers]))/(ISNUMBER(SEARCH("*"&$A3&"*",st_items))*(st_department=$E3)),1)=0,"",INDEX(INDIRECT("st_"&D$2),AGGREGATE(15,6,(ROW(st_items)-ROW(tbl_stores[#Headers]))/(ISNUMBER(SEARCH("*"&$A3&"*",st_items))*(st_department=$E3)),1)))

 

[Mchllwoods]

It works!!! Thx so very much!

 

[Peter_SSs]

It works!!! Thx so very much!

You're welcome. Thanks for the confirmation.