Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index function?
Good morning:
I created a table to compare vendor prices... Columns: = vendor's name Row = Item number I would like to find which vendor offer the best price and would like to enter a formula in a cell that would give me the name of the lowest bidding vendor for every row. I have been able to calculate the lowest price using the small formula. How could determine which vendor has the smallest price? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index function?
Try this:
B1:E1 = vendor names B2:E2 = vendor prices =INDEX(B$1:E$1,MATCH(MIN(B2:E2),B2:E2,0)) Note: if there are more than 1 vendor with the lowest price the formula will return the name of the leftmost vendor. Biff "MIchel Khennafi" wrote in message ... Good morning: I created a table to compare vendor prices... Columns: = vendor's name Row = Item number I would like to find which vendor offer the best price and would like to enter a formula in a cell that would give me the name of the lowest bidding vendor for every row. I have been able to calculate the lowest price using the small formula. How could determine which vendor has the smallest price? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index function | Excel Worksheet Functions | |||
Returning an array from the INDEX function | Excel Worksheet Functions | |||
INDEX function need to have col reference to be formula | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |