I am trying to get an index formula to work and achieve the following:
I will have one sheet with a lot of data: part number(A) location(b) and qty(c) that are the important columns for this project.
I will have a search sheet part number(A) location(b) and qty(c).
Part Number 123 entered into ("A2") could have 9 locations and 9 qty so what I would like to do is use an index formula to return all the matching values from the master sheet for columns (B) and (C).
I know it should be an easy index formula within an iferror that I could just drag down and should populate all results I just cant get it to work
Please advise
Test.xlsx
Bookmarks