Copy data from 5th column if data in previous 4 matches

[UrosB]

Hello,
This is my first post here and I'm relatively new to excel so hopefully somebody can help me.
I have workbook with 2 sheets (Sheet3 and Sheet4) in which one contains 4 columns and the other one contains 5 columns and I need a formula that will copy data from 5th column in second sheet to the first sheet if data in 4 cells in a row matches on both sheets. In the first sheet data starts in cell B4 and in second sheet it starts in cell A1 so data in column B in Sheet3 should match data in coulmn A on Sheet4 and so on and if there is match in all 4 cells in a row then it should copy data from 5th column.

 

[Special-K99]

Formulas can't copy data to other cells, you need VBA for that.

A cell can contain a value or a formula.
A cell can contain a value based on another cell but not copy a value to a cell.

This looks like a VBA solution may be required of which I'm no expert.

 

[UrosB]

Formulas can't copy data to other cells, you need VBA for that.

A cell can contain a value or a formula.
A cell can contain a value based on another cell but not copy a value to a cell.

This looks like a VBA solution may be required of which I'm no expert.

Ok, thank you for your response. I don't mind it being VBA or formula, I would just like not to do it manually as there is a lot of data.

 

[mart37]

you can use SUMSIF() or SUMPRODUCT()

=SOMPRODUCT((B4=sheet4!$A$1:$A$21)*(C4=sheet4!$B$1:$B$21)*(D4=sheet4!$C$1:$C$21)*(E4=sheet4!$D$1:$D$21),sheet4!$E$1:$E$21)