Forum Discussion
I need help with a formula collecting data from one sheet to another
Hi Communitie I hope that you can help me.
In a file with two sheets i have column C with costumer names and numbers in both sheets.
In sheet A I also have their turnover.
In sheet B (bes...
Hia,
this will work:
=INDEX('Ark2'!G:G,MATCH('Ark1'!C13,'Ark2'!C:C,0))
I've assumed that you get this report given to you and your want something you can just add and know it will work without any additional work? Which is why its using whole columns.