I need help creating a formula that will return the vendor name based on their cost. I need the formula to return the lowest 3 vendors. The formula will be used in COLUMNS B,C,D.
I've tried using the INDEX,MATCH function combo but I'm not having any luck. Below is an example of the data I'm...