Forum Discussion

Michael Kønig's avatar
Michael Kønig
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
Michael Kønig's avatar
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's avatar
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.

Resources