How can I do this in excel?

burgonyapure

New Member
Joined
May 31, 2019
Messages
3
I can't describe my problem any better:

if (sheet1!A1 == sheet2!A1 && sheet1!A2 == sheet2!A2) {
sheet2!A10=sheet1!A3;
}

If a cell equals to another cell on another sheet, then a given cell should have the value of a cell from another sheet.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,072
Office Version
365
Platform
Windows
Something like this in the 'given cell'

=IF(AND(Sheet1!A1=Sheet2!A1,Sheet1!A2=Sheet2!A2),Sheet2!A3,0)
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,821
Members
406,500
Latest member
Tknotmaxx

This Week's Hot Topics

Top