Global search and return

[RmarkR]

Hi,
After wrestling with this for weeks and fruitless searches I turn to the community.
Any tips or steering to corresponding threads would be helpful.

I am trying to create a formula that will search through a whole sheet, find multiple cells in small tables containing a unique identifier, return them all to a table together with corresponding cells.
I've tried arrays and aggregate function with no luck.

Thanks in advance for any help.
Mark

 

[Somendra Misra]

Hi Mark,

How many such tables are there in your original file?

Regards,

 

[RmarkR]

Currently there are 15. I want the ability to copy+paste any table and then have the formula automatically include the data from the new table because of the unique identifier in a table.
Of course I want to have a global search in case the table is not pasted directly in the same columns...