I have an excel spreadsheet where I have a list of vendors and a list of prices and to summarize these I have a cell that pulls in the MIN of the prices but i cannot figure out a way to pull in the vendor that matches the MIN price. Can someone help me?
Welcome to the forum
=index(vendors, match(min(price), price, 0))
Entia non sunt multiplicanda sine necessitate
its giving me an error...Originally Posted by shg
so it should be =index("select all vendor cells", match("min price cell", *What is this price to be?, 0))
is that correct?
I dunno, post a workbook.
take a look at this
You're working uphill if you try to arrange data like that in Excel.
In the attachment, data is arranged in database fashion. Enter an item number in A2 and see the minimum price and vendor in E2 and D2.
Both E2 and D2 are array formulas, which means that the must be confirmed with Ctrl+Shift+Enter, not just Enter like you're used to. That's what makes the curly braces appear in the formula bar -- you can't type those in directly.
The formulas reference dynamic named ranges that automatically extend down as far as you have entries in column A.
Hello,
Can you please tell me how to get the name of the vendor automatically?
Tmilios,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@ gmarma
I had attached the file for your reference. There are also two simulation. Unfortunately, this formula could only show one vendor name even if there are two vendors with the same low price.
Formula:
Please Login or Register to view this content.
Click * to reward me...
Thank you...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks