Dear Experts,

I've a table of data and wonder whether or not it's possible to use Vlookup
or Hlookup to find and list multiple rows of matching records. Please see
example below:

Name Supplier Cost
Bk-Alpha ABC & Co 99.00
Bk-Beta 123 & Co 89.00
Bk-Apha XYZ & Co 95.00

From the above scenario, how do I go about to find "Bk-Alpha" and display
all matching rows, ie: show ABC & Co, XYZ & Co and so on?

I would really appreciate any kind help.

Million thanks.
Rich