I need the file number on A column copy and paste to other sheets base on column C and E

Very confusing thread!
2002700 is in column C and Row 183. Column E of the same row says Thank you----

There is not a value with 2004001 in column A. This is found in column C, rows 212-213.
Need better explanation, or better attach a desired output.

Originally Posted by 1Melina

look at the column C, from C2:C, find 2002700, the same row on E column should say, Thank you A merchandise return label will be sent to your email address you provided on your order within 48 hours, if this is correct.

But it doesn't. The first instance of 2002700 is in cell C182. The same row on E column (E182) says "Current Level Id is : 2002700".

Go down on cloumn C, under the same file numbers on Column A, find 2004001, if it says Press 1 for yes or 2 for no. copy the file number to the sheet that is says transfer, and if doesn't say that copy the file and paste to hang up sheet.

Another problem, The column A value (svru6125520131014141641) has multiple entries with 2004001. Of those multiple entries, there are multiple "Press 1 for yes or 2 for no".

Too many inconsistencies for me. Best of luck.

I copy the file number on the same row on column A.?

Once 1008 is found and column E is Thank you which row or column do you copy in to sheet transfer? What is the relevance of column A?

The row that says transfer on transfer sheet and the row that is saying hang up to hang up