if 2 cells in one row match 2 cells in another row copy a cell

Hello,

i have tried to do this but can’t seem to figure it out.

i have a work book with 2 sheets and I want it to match two columns with two columns on anouthher sheet and if they are the same then to copy anouthrr column. Example bellow

sheet1
A................. B. .... E
Cable#.......Side......unit
1. Cable1 _____. Unit1.
2. Cable 1 _____. Unit2.
3. Cable 2. ______. Unit1.
4. Cable2. ______. Unit3.

sheet 2
A. ............B. ..........C
Cable#. Unit#..... Side
1. Cable1 Unit1. SideA
2. Cable 1 Unit2. SideB
3. Cable 2. Unit1. SideA
4. Cable2. Unit3. SideB

So what I need is if sheet1 A1&E1 are the same as sheet2 A1&B1 then sheet2 C1 will copy to sheet1 B1

note the lines on sheet 2 are all over the place but the unit will always go with the cabl# on both sheets. There are multiple lines with the same unit which is why it has to match the cable#. The side a & b of the cable # will always be different unit #s

thanks in advance

tyler

Thank you very much this worked perfectly.

Cross post almost fixed. I requested it to be deleted. Was going to do that last night but I lost power. and could not do it from work because I dont have access to that site there. ""this single post can be deleted"" but please keep the main thread open.

Sorry for the inconvenience