# Finding Lowest Cost/Vendor

1. ## Finding Lowest Cost/Vendor

I have a 2200 item quote. We’ve got pricing from 3 different vendors. I need to find the lowest price, mark it up and designate which vendor it’s from so the CSR knows which one to quote back to the customer. Besides going through it line by line, is there a way to do this? It seems like there could be a formula where it pulls the lowest of the 3 prices and vendor name into a new “price” and “vendor” columns and then I can go through and mark it up.

Here’s a small sample of what the sheet looks like:

Item # Desc V1 V1 Cost V2 V2 Cost V3 V3 Cost
123456 brush Advance 2.56 Weiler 5.65 Osborn 3.25

2. Assuming your entries begin in A2:L2 , then in M2 (or anywhere else in same row) enter =Min(B2:L2) and copy down...

In N2 enter: =INDEX(B2:L2,MATCH(M2,B2:L2,0)-1) where M2 is the place you put your minimum value formula... copied down.

3. thank you so much!!! That worked perfect.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1