I want to extract the transactions from column H that match the specific product in column J, but at the same time, it should match location 65 location data is in column A the attached picture show the full data details.
currently I'm using =INDEX($H:$H,MATCH(1,(($B:$B=J2)($D:$D>=$K$3)($D:$D<=$L$3)),0))
how can I expand the above index formula to include the specification of location 65
the formula should return the transactions that were made between two dates k3 start date and L3 end date for each product line in the J column and also those transactions should be made by 65 location from the data given at column A
I really need your help on this I have been looking for a resolution to my request.index-match-multiple-criteria.pngBook1.xlsx
Bookmarks