Formuala to return "account Paid" if no match

[howard]

I have tried to set up a formula so that where the No. in Col J in the destination workbook is not on Col F on the source workbook, then "Account paid" to be returned. If the account No. in Col Jis found in Col F in the source data, Then "account not settled" to be returned

It would be appreciated if someone could kindly amend my formula

=IFERROR(IF(VLOOKUP(J2,'[Creditors.xlsm]Imported Data'!$F:$F,1,0),"Account Paid")<>"account Paid","account not settled")

 

[Norie]

If you want to return Account Paid/Account not settled based on whether the value in J is found in column F on 'Imported Data' try this.

=IF(ISERROR(MATCH(J2,'[Creditors.xlsm]Imported Data'!$F:$F,0)),"Account not settled", "Account Paid")

 

[Aladin Akyurek]

Looks like...

=IF(ISNUMBER(MATCH(J2,'[Creditors.xlsm]Imported Data'!$F:$F,0)),"account not settled","account paid")

 

[howard]

Thanks for the help, much appreciated

 

[Norie]

Oops, got it the wrong way round.

 

[howard]

Sorry meant to inform you that I picked it up that it should have been the other way around

 

[Aladin Akyurek]

Thanks for the help, much appreciated

You are welcome.