How to add a condition on to an existing formula?

[rabbitsfeat]

I've got this bit of code so far:

=IFERROR(INDEX([EbayAmazonWeeklyReport.xlsx]Sheet1!$A$2:$F$2359,MATCH(C2,[EbayAmazonWeeklyReport.xlsx]Sheet1!$C$2:$C$2359,0),2),"")

This matches up the number in column C2 on one spreadsheet, with column C2 on another spreadsheet. Then brings over the info from column B2 in the second spreadsheet.

I want to add another condition to this. The information in column E2 on the second spreadsheet must say AMZ, and only bring it over if it does. If it says anything else do not bring it over. So it has to be an exact match.

So I want the info from column B2 brought over, but only if column E2 says AMZ.

How do I go about doing this?

 

[rabbitsfeat]

Another possibility would be to only bring over numbers in column B2 that match a certain format. Only the numbers that look like this:

202-7887844-0998725. Only numbers that equal a 3-7-7 format.

<tbody>
</tbody>

 

[Sandie1712]

Hi,

I think it should work

=IFERROR(INDEX([EbayAmazonWeeklyReport.xlsx]Sheet1!$A$2:$F$2359,IF($E$2="AMZ",MATCH(C2,[EbayAmazonWeeklyReport.xlsx]Sheet1!$C$2:$C$2359,0)),2),"")