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?

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

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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.

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

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>