INDEX(MATCH) or JOIN(COLLECT)?
When we first started using Smartsheet, the rep who handled our "Launch Package" created the following formula.
It searches two sheets for "OurPN" and when it finds a match it returns the Supplier PN. The problem is there may be multiple suppliers that have their own "supplier PN" for "OurPN". So, it returns the first match it finds.
I want to be able to search multiple sheets and match "OurPN" and a specific supplier then return the supplier PN.
Not sure if INDEX(MATCH) or JOIN(COLLECT) would work better. Any suggestions?
Help Article Resources
Check out the Formula Handbook template!