Forum Discussion
Solved
Vlookup with multiple returns fix?
Here is my current formula. =IF(VLOOKUP(B10,InvoicesMain[[Company]:[Notes]],5,FALSE)<>"Complete", "Yes", "No") In basic, its looking for a customer and then determines if the service request is ...
Does this do what you want?
=IF(COUNTIFS(InvoicesMain[Company],B10,InvoicesMain[Notes],"<>Complete"),"Yes","No")
Unfortunately, with the way the document is formatted, I couldn't do that one.