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 anything other than Complete. My issue comes in when I have the same customer open a second service request. It'll return the first one it finds and not continue looking for the second one. I would link the document but it has personal information of my customers on it.
Does this do what you want?
=IF(COUNTIFS(InvoicesMain[Company],B10,InvoicesMain[Notes],"<>Complete"),"Yes","No")
9 Replies
HansVogelaar This is what the format looks like. Maybe it'll help give some ideas
What would you like the formula to do exactly?
- Unfortunately, with the way the document is formatted, I couldn't do that one.
