Forum Discussion
Solved
VLookup + multiple answers
I have created a spread sheet of client names and numbers and am using VLOOKUP to bring up information. The lookup is by last name and there are instances where there are more than one in the list. ...
This
=FILTER(Providers!A2:G150,Providers!A2:A150=B6)might work.
It's very similar to what Harun24HR has already suggested. The only difference is that FILTER uses e.g. Providers!A2:G150 instead of e.g. A.:.B.
This
=FILTER(Providers!A2:G150,Providers!A2:A150=B6)might work.
It's very similar to what Harun24HR has already suggested. The only difference is that FILTER uses e.g. Providers!A2:G150 instead of e.g. A.:.B.
Excellent! That's beautiful. Thanks