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

[- - - RyK4Rd0 K4Mp0x - - -]

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

[#2]

see photo attached
Need Help :S

[#3]

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.

[#4]

Hello

i will try you recomended combination.

About my Id, Alredy changed ;)

Thank You

Have a good week

[#5]

Thank you Sergei Baklan

Work now... hard, but working 100% ;)