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
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