Re: VLookup + multiple answers

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.