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

 

See attachement

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP

      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.

Resources