Vlookup issue flagging up #N/A

[mrsushi]

Good morning,

I have the following formula in Column G which is return the results i want i.e. LOADED or NOT LOADED.

However, if the value is not in the list from another sheet(Extract), this returns a #N/A error

How can my formula be amended to return a narrative to say "Not on list"?

Current formula:

=IF(VLOOKUP(B75, Extract!A:D, 4, FALSE)='Business Date'!$B$2, "LOADED", "NOT LOADED")

Many thank
M

 

[arthurbr]

Perhaps

=IFERROR(IF(VLOOKUP(B75, Extract!A:D, 4, FALSE)='Business Date'!$B$2, "LOADED", "NOT LOADED"),"Not on list")

 

[mrsushi]

Perhaps

=IFERROR(IF(VLOOKUP(B75, Extract!A:D, 4, FALSE)='Business Date'!$B$2, "LOADED", "NOT LOADED"),"Not on list")

Thats perfect. Many thanks
Regards
M

 

[arthurbr]

You're welcome