IF Statement which includes conditions and provide specific result

[shahid5788]

Hi,

I had a question regarding my information below. As you can see my raw data below. In Column D you will see what results I want. I am trying to find a If statement that will look into column E (ID#) and column G (Item) and if those are same information as cell C3 then return the C3 information in column D


Can someone please assist?




[TABLE="width: 2087"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Dt[/TD]
[TD]Memo / Description[/TD]
[TD]PO NUMBER[/TD]
[TD]What I Want[/TD]
[TD]ID #[/TD]
[TD]Customer Name[/TD]
[TD]Item[/TD]
[TD]USD[/TD]
[TD]USD[/TD]
[/TR]
[TR]
[TD]9/27/2017[/TD]
[TD]Invoice - Auburn University: 500drt, htfJW2, vertical orientation [/TD]
[TD]IF Column G and H have same information as cell C3 then choose C3 content[/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]PTTUA0080[/TD]
[TD] [/TD]
[TD]10,000.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9/27/2017[/TD]
[TD]Invoice - Auburn University: SF 147634 Purchase Billing - PO475[/TD]
[TD]PO475[/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]BACK0054[/TD]
[TD] [/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9/25/2017[/TD]
[TD]HA22 - Pannel Shipping List - 22: 2017/10/25 Patch[/TD]
[TD]IF Column G and H have same information as cell C3 then choose C3 content[/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]BACK0054[/TD]
[TD]60.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9/25/2017[/TD]
[TD]HA22 - Pannel Shipping List - 22: 2017/10/25 Patch[/TD]
[TD]IF Column G and H have same information as cell C3 then choose C3 content[/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]PTTUA0080[/TD]
[TD]8,000.00[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

Your question and example are having inconsistent references.
Take a close look at what your asking and make sure it's in line with the sample.

 

[shahid5788]

Hi sorry for the confusion. I hope I can make it more sense now. So what I want is that to have a IF statement that will go into column E and column G and if those same information is being repeated again then return the value of column C. As you can see in Item BACK0054 and ID 12 is being shown twice in the data below and I want a formula that will return the value of "PO475" if that make sense.





[TABLE="width: 1817"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Doc Dt.[/TD]
[TD]Memo / Description[/TD]
[TD]PO NUMBER[/TD]
[TD]What I Want[/TD]
[TD]ID #[/TD]
[TD]Customer Name[/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD]9/27/2017[/TD]
[TD]Invoice - Auburn University: 500drt, htfJW2, vertical orientation [/TD]
[TD][/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]PTTUA0080[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/27/2017[/TD]
[TD]Invoice - Auburn University: SF 147634 Purchase Billing - PO475[/TD]
[TD]PO475[/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]BACK0054[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/25/2017[/TD]
[TD]HA22 - Pannel Shipping List - 22: 2017/10/25 Patch[/TD]
[TD]If column E and G have same information shown then return value from column C[/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]BACK0054[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/25/2017[/TD]
[TD]HA22 - Pannel Shipping List - 22: 2017/10/25 Patch[/TD]
[TD][/TD]
[TD]PO475[/TD]
[TD]12[/TD]
[TD]Auburn University[/TD]
[TD]PTTUA0080[/TD]
[/TR]
</tbody>[/TABLE]