Forum Discussion

Mgaltieri's avatar
Mgaltieri
Copper Contributor
Jul 11, 2023
Solved

Excel function

  I need to write an excel function that: If column B color is #FFC7CE, then take column C value and copy it to D as many times Column B value is repetead on column A.   This is how it should l...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 11, 2023

    Mgaltieri 

    Okay, thank you. Perhaps you mean

    with formula in E1 as

    =IFERROR( INDEX( C:C, MATCH( $A1, B:B, 0 ) ), $C1 )

    and drag it down.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 11, 2023

Mgaltieri 

Okay, thank you. Perhaps you mean

with formula in E1 as

=IFERROR( INDEX( C:C, MATCH( $A1, B:B, 0 ) ), $C1 )

and drag it down.

Mgaltieri's avatar
Mgaltieri
Copper Contributor
Jul 11, 2023
Awesome! Thank you very much Sergei for your help!

Resources