Contain, If, Index/Match formula to cross reference

GNg

Hello

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!

Paul Newcome

Have you looked into creating a report?

GNg

Hi Paul

I actually need to pull the notes from multiple sheets in accordance with the same "No." and the report is unable to cross them into the same row. Hence that's why I am trying to compile them using the sheet instead.

Thanks