Matthew Baumann
New Member
I am trying to find a way to look up any matches of part numbers in 2 sheets and then return any of the corresponding matches on a single line. At the moment it's only returning the first match found.
The attached picture shows what I have and what I'm looking to achieve - a way to put all the results from the Find function on another tab (same sheet) into the cells highlighted.
When I look at array formulas I start to get lost pretty quickly so any help would be appreciated.
The attached picture shows what I have and what I'm looking to achieve - a way to put all the results from the Find function on another tab (same sheet) into the cells highlighted.
When I look at array formulas I start to get lost pretty quickly so any help would be appreciated.