• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup/cross reference formula help needed

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.
 

Attachments

  • Array.jpg
    Array.jpg
    376.5 KB · Views: 5
Back
Top