Index Match formula work around for Dynamic View
I am trying to find a solution for a sheet that has multiple lines with the same store#'s and inventory on multiple rows. This is not a shared sheet to our group, so I want to be able to index match this information to another sheet so we can use the info for internal purposes. I dont have the knowledge of how to use the formula when there are the multiple same store numbers in the row headers that would error out on a single result.
Help Article Resources
Check out the Formula Handbook template!