Converting from google sheets to excel

Hello! My company recently did a complete changeover from google to microsoft. There is a very useful document that wasn't translating the formulas correctly. There is no "error" response but it will...

Formulas and Functions

HansVogelaar
Apr 27, 2022
amuench16

The formula in C3 should be

=IFERROR(INDEX(INDIRECT("'"&C$2&"'!$G4:$AA$1000"),MATCH($B3,INDIRECT("'"&C$2&"'!$F4:$F$1000"),0),MATCH($C$1,INDIRECT("'"&C$2&"'!$G$3:$AA$3"),0)),"")

Fill down and to the right. And the formula in C24 should be

=IFERROR(INDEX(INDIRECT("'"&C$2&"'!$AE4:$AY$1000"),MATCH($B24,INDIRECT("'"&C$2&"'!$AD4:$AD$1000"),0),MATCH($C$1,INDIRECT("'"&C$2&"'!$AE$3:$AY$3"),0)),"")

Also fill down and to the right.

amuench16

Copper Contributor

Apr 27, 2022

I have sent the link
Thank you!!!!

HansVogelaar

MVP

Apr 27, 2022

amuench16

The formula in C3 should be

=IFERROR(INDEX(INDIRECT("'"&C$2&"'!$G4:$AA$1000"),MATCH($B3,INDIRECT("'"&C$2&"'!$F4:$F$1000"),0),MATCH($C$1,INDIRECT("'"&C$2&"'!$G$3:$AA$3"),0)),"")

Fill down and to the right. And the formula in C24 should be

=IFERROR(INDEX(INDIRECT("'"&C$2&"'!$AE4:$AY$1000"),MATCH($B24,INDIRECT("'"&C$2&"'!$AD4:$AD$1000"),0),MATCH($C$1,INDIRECT("'"&C$2&"'!$AE$3:$AY$3"),0)),"")

Also fill down and to the right.

amuench16
Copper Contributor
Apr 27, 2022
That worked perfectly. Thank you!!

Forum Discussion

Converting from google sheets to excel

Resources