vlookup multiple values and return only the smallest value found.

[confused_student]

Hi all, so here's the problem. I have an excel sheet with multiple columns. In one column I have X's and in another I have a limit. I need to look down the stuff column, find every X, match each X to its corresponding limit and then compare all the limits and return only the smallest limit found. I.e if I was looking down the stuff column I would find 4,6,8,8,3 and thus I would return 3 as my value. I am very new to working with excel formulas, so please be kind. thanks in advance[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]limit
[/TD]
[TD]something
[/TD]
[TD]stuff
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4
[/TD]
[TD][/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]5
[/TD]
[TD]x
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]8
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]8
[/TD]
[TD][/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[/TR]
</tbody>[/TABLE]

 

[confused_student]

I know this question has been handled many times before over the internet but I couldn't get their codes to work with the addition of looking for the minimum value.

 

[Weazel]

You can try this, but I'm not sure how you would want to handle duplicate minimum values or if the 'something' column has any impact.


Excel 2010

	A	B	C
x
x
x	x
x	x
x
x	x

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FDE9D9"]limit[/TD]
[TD="bgcolor: #FDE9D9"]something[/TD]
[TD="bgcolor: #FDE9D9"]stuff[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]5[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="bgcolor: #FDE9D9, align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]A10[/TH]
[TD="align: left"]{=MIN(IF(C2:C8="x",A2:A8))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

 

[confused_student]

Thanks for the quick reply. If I have multiple instances of the lowest limit I need to check it against two additional columns. so if I looked down stuff id find limits of 3,4,3 and take the two 3s, then look at the 2nd limit and if they match look at the 3rd limit where if they still match I just take the first instance, but if not take the lowest value. Any ideas?[TABLE="width: 500"]
<tbody>[TR]
[TD]3rd limit[/TD]
[TD]2nd limt[/TD]
[TD]limit[/TD]
[TD]stuff[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[confused_student]

bump