Lookup

I need to lookup excel ( I dont want to use Pivot table) I have date in one sheets with three columns “Product” , “qty sold”and “city” And in other sheet i want it in the way that, the table wit...