Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Relative Data from result of MIN function
I will attempt to explain my problem below and I wanted to provide as much information as I could, hence the lengthy post :) My first worksheet has 3 cells, A1, B1, C1, that displays "Minimum price", "Vendor" and "Description" respectively. I have two more sheets that are arranged the same way as the first sheet except A1 displays a numerical value instead of the "minimum price". B1 displays a vendor name, and C1 displays a description. On the first sheet under A1 to find the minimum price, I used the MIN function to find the minimum value among the values in A1 in Sheets 2 and 3, i.e. =MIN(Sheet2!A1, Sheet3!A1). How do I display the corresponding vendor and description of the resultant minimum value? For example, assume the following data for sheets 2 and 3: SHEET2: *----A----B-------------C* 1[/b]---10---VENDOR 1----PRICE OF HAT *SHEET3: *----A----B-------------C* 1*---20---VENDOR 2----PRICE OF SHOE SHEET 1 WOULD DISPLAY THE FOLLOWING: *SHEET1: [b]----A----B-------------C* *1*---10---Vendor 1----Price of hat I know I can probably use IF statements to achieve this, but for that to work I would need to know exactly the number of sheets I'm dealing with, i.e., Sheet 2, 3, etc plus as the number of sheets increases, the IF statement would get very lengthy. Is there a way I can do this without using IF statements? Is there a way the MIN function can return the actual cell or sheet reference instead of the value? Any help or advice will be appreciated. Thanks -- bigmacrox ------------------------------------------------------------------------ bigmacrox's Profile: http://www.excelforum.com/member.php...o&userid=30122 View this thread: http://www.excelforum.com/showthread...hreadid=498110 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Result from data in two columns....Best function to use? | Excel Worksheet Functions | |||
How to sort data that is the result of a sum function | Excel Worksheet Functions | |||
Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
Relative Value to a Vertical Lookup Result? | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |