Report based on 3 sheets with the same primary column

Jean-Daniel ADEGBIDI · 04/24/20

Hi everyone,

i want to make a report based with 3 sheets (Financial informations, planning informations, others informations) which have a common reference in their primary column. I want to have all the informations automatically on the same line.

Please, can someone help me?

Thanks.

Andrée Starå · 05/06/20

@Jean-Daniel ADEGBIDI

I saw that Joachim answered already and he is correct!

We would either use a VLOOKUP or a combination of INDEX/MATCH to make it work.

https://help.smartsheet.com/function/vlookup

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Let me know if I can help with anything else!

Andrée Starå · 04/24/20

Hi Jean-Daniel,

You would have to combine the information on another sheet first to be able to get it to show on one row.

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jean-Daniel ADEGBIDI · 04/24/20

Hi,

Thanks for your answer. So, basically i can merge 3 sheets into one. But how can i automatically merge 3 lines from 3 differents sheets which have the same word (reference) into one line?

Joachim Mund · 05/05/20

with vlookup in each column and reference to one of the three sheets, would that work for you?

Andrée Starå · 05/06/20

@Jean-Daniel ADEGBIDI

I saw that Joachim answered already and he is correct!

We would either use a VLOOKUP or a combination of INDEX/MATCH to make it work.

https://help.smartsheet.com/function/vlookup

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Let me know if I can help with anything else!

Jean-Daniel ADEGBIDI · 05/06/20

Hi,

Thanks for the help, i will try it.

Andrée Starå · 05/06/20

@Jean-Daniel ADEGBIDI

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Report based on 3 sheets with the same primary column

Best Answer

Answers

Categories