Quote:
In cell D2 of ReportOwnerQuery: =VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE) returns a #N/A
In cell D2 of ReportOwnerQuery: =VLOOKUP(&"*",OwnerList!A1:A1000,1,TRUE) returns an incorrect email from OwnerList
This is exactly the expected behavior for VLOOKUP.
Quote:
If one of those emails is an owner email for the cell then place in in Column D of ReportOwnerQuery.
Yes but what to put in cell when there is no match ?
Because the behavior you describe is the one when the email address is not in the list.
I would try something like:
=IF(ISERROR(VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE)),your result,your result)
or
=IFERROR(VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE),your result)