Hi I'm trying to create a formula or macro that outputs three results. There
is a data validation, and once the type is selected, the formula would go
through the table on another sheet in the workbook and look for a match for
that type. Once found, it will populate three vendors with largest spend and
their addresses.
For example.
If the type was Apple. It would look through a long list with these headers
and the output would be Vendor A, B, and C and their addresses. If there is
only one vendor for that type then only one vendor name would show up but if
none then it would be blank.

Type Vendor Name Spend Address City ST Zip
Apple VendorA 500 any any any any
Apple VendorB 100
Apple VendorC 25
Apple VendorD 10
Orange VendorE 85
Orange VendorF 40
Lime VendorG 5
Lime VendorH 2
and so on ...
'
Thank you