Forum Discussion

- - - RyK4Rd0 K4Mp0x - - -'s avatar
- - - RyK4Rd0 K4Mp0x - - -
Copper Contributor
Feb 02, 2017

Help: Excel function copy to (D2) ''sheet1'' the number in (c2) ''Sheet2'' if (A2) ''Sheet1'' ......

Hello,   I need 1 function to make this:   copy to (G5:G9) ''sheet1'' a number it's in (C16:C20) ''Sheet2'' if (B5:B9) ''Sheet1'' iqual to (B16:B20) ''sheet2''     Can Help me please   Se...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 04, 2017

Hi,

 

Use INDEX/MATCH combination. By the way, i hardly recommend you to change your ID here on more human friendly to receive answers in this community.

  • - - - RyK4Rd0 K4Mp0x - - -'s avatar
    - - - RyK4Rd0 K4Mp0x - - -
    Copper Contributor
    Feb 08, 2017

    Hello

     

    i will try you recomended combination.

     

    About my Id, Alredy changed ;)

    Thank You

     

    Have a good week

Resources