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.
Apparently, this is Excel 365. I knew about VLOOKUP from previous versions. I'm trying to set up a SEARCH by inputting a name on one page that looks up the name on a second page and returns the associated information back onto the first page.
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