Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying text value based on long (comlex) calculation
I am not sure how to even search for what I want to do, so please forgive me if my first post has been discussed and resolved ad naseum in the past... Here is my situation: - I have a workbook that contains multiple sheets. - Each sheet contains auto parts from different suppliers, sorted by part number. - Some suppliers have parts that overlap with each other and the various sheets are updated as pricing and availabilty of parts change. - I am using the VLOOKUP and MIN functions to determine which supplier has lowest cost based on a comparison of part numbers and price across each supplier. - The first sheet is a summary and contains all of the part numbers (entered manually), as well as the lowest cost from any supplier's worksheet (as calculated above). - Cell A1 of each supplier sheet has the company name in it. My question is this: - For each part number listed on the summary page, I want to display the name of the supplier who has the lowest cost for the item in question. -- gezuvor ------------------------------------------------------------------------ gezuvor's Profile: http://www.excelforum.com/member.php...o&userid=30383 View this thread: http://www.excelforum.com/showthread...hreadid=500451 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
Copying Text to Clip Board Using a Macro | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
returning a text cell based on a number cell | Excel Worksheet Functions |