formula problem

[howard]

I have code in Col I on the current workbook for eg 'MA147749 and have set up a formula to find out if it exists in Col F o the source workbook


If it exists a 1 is returned , otherwise zero

 =IF(MATCH(I2,'[Sales Report.xlsm]Imported Data'!$F:$F,0),1,0)

The formula works well, but need it amended so that if the value in Col J on workbook 'Sales Report.xlsm]Imported Data'! pertaining is zero, then is must reflect as "paid", otherwise "not paid"


Kindly amend code

 

[Jonmo1]

Try

=IFERROR(IF(VLOOKUP(I2,'[Sales Report.xlsm]Imported Data'!$F:$J,5,0)=0,"paid","not paid"),0)

 

[howard]

Thanks for the help. your formula produces the desired result

 

[Jonmo1]

You're welcome.