I am using the following formula:
{=INDEX('Export'!$A$1:$C$20000,MATCH(FALSE,ISERROR(SEARCH('Manufacturer''s Parts'!$B2,'Export'!$C$1:$C$20000)),0),2)}
On sheet Export, I have a list of our part numbers in rows with their descriptions. Contained in the description is a part description and several manufacturers and manufacturer's part numbers that correlate to our part number.
On the Manufacturer's part number sheet, I have a list of the manufacturer's part numbers. The formula searches through all of the Export and when it finds a match, it returns our part number that the match occurred on.
What I am looking to do is to create one or more additional columns. These columns would return the 2nd, 3rd, etc. part number that may match (and return a Null, error, etc once no additional matches are found). I am not sure how to change the above formula for these subsequent columns. I think the main reason I am having trouble is that I am not very familiar with how array formulas work.
Any help would be appreciated.
Bookmarks