Contain, If, Index/Match formula to cross reference


I have sheet 1 as a reference database as below:

Sheet 1:

And I would like to pull data from Sheet 1 to Sheet 2 only from customer CA.

Sheet 2:

Could you please help me to develop a formula as I have more than 10000 No. to cross reference? Also it would be better if I can use INDEX/MATCH formulas as I need to refer more than 100K cells.

Thanks a lot!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!