Hi Everyone,
You've saved me before, and I was hoping you would be able to help me out again.
I have a large data set that contains many lines of product information (raw data table). I am creating an analysis table that extracts data from the raw data table.
Ultimately, I would like to use serial numbers as the base, and conduct some sort of if, index, match combo to extract the data I need.
The problem I am running into occurs when there are duplicated serial numbers in the raw data table. I believe if I add an additional criteria that returns the data based on whether the destination is a retail store or WHS, I should be able to fix this issue. With that said, I haven't been able to figure out how to fix the problem on my own
I have attached a sample data file with the current index, match formula I am using.
Bookmarks