Forum Discussion
- - - RyK4Rd0 K4Mp0x - - -
Feb 02, 2017Copper Contributor
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
- - - - RyK4Rd0 K4Mp0x - - -Copper Contributorsee photo attached
Need Help :SHi,
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 - - -Copper Contributor
Hello
i will try you recomended combination.
About my Id, Alredy changed ;)
Thank YouHave a good week