How to find a minimum value with a vlookup and a condition?

[anthonyu]

Hi all,

I am trying to get a formula with a vlookup which will enable me to find the minimum value for a specific code. I would also like that the formula exclude the results which are less than 100?

My formula is the following:

=MIN((VLOOKUP(G3,A:B,2,FALSE)))

How can I add a condition? i,e exclud from the result the figures which are bellow 100

I have attached my excel spreadsheet as well (I think it will make more sense)

[DGagnon]

try this array formula (confirmed with Ctrl+Shift+Enter)

=MIN(IF(($A$1:$A$34=$G3)*($B$1:$B$34>=100),$B$1:$B$34))

it did return different values than what you had specified in Column I, but they appear to be correct.

[icestationzbra]

do not duplicate posts - you are wasting people's time:

http://www.excelforum.com/excel-gene...condition.html

[Paul]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.