Forum Discussion

Copper Contributor

Sep 25, 2018

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...

excel

Formulas and Functions

Philip West

Iron Contributor

Sep 25, 2018

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.

Michael Kønig

Copper Contributor

Sep 25, 2018

Hi Philip

Thanks your response:
I can see the whole idea in the formula and despite the fact that I have to translate INDEX and MATC to the danish version I still can´t get the result I want.

Are you shure that the last zero is correct ?? I can´t see the refernce for that ?

Philip West
Iron Contributor
Sep 25, 2018
https://en.excel-translator.de/translator/

I'm not sure about the comer/semicolon options, but its a good tool.

The 0 specifies the type of match we want, in this case 0 is an exact match which is what we want.

I'm uploading a copy, of your workbook which works for me, not sure if that will help given the localization.

Also just noticed the formula should have been:

=INDEX('Ark2'!G:G,MATCH('Ark1'!C7,'Ark2'!C:C,0))

Not C13 in the first one. Sorry, that might be whats messing it up for you.