How can I fill out columns in the sheet from another sheet?

Hi Team.

I am working on integrating data from 2 sheets. For instance, in sheet 1 we have Project ID, Resource Assignment, Time Allocation. In sheet 2, we have "Project ID", "Category", "Product Manager".

I would love to make a sheet including below information:

"Project ID"( sheet 1) , "Category Name, Product Manager" (sheet 2), and Time Allocation (Sheet 1)

It requires me to use functions such as excel function "XLOOKUP", but I couldn't modify any of these sheets beside using them.

So I would need a solution to integrate the information from 2 sheets. My assumption would be using Report, but in the report they can only simply add up rows.

Thanks in advance.

-Alice

Answers