Can I use VLOOKUP to bring back MIN values?

[ralldredge]

Hi! I am trying to use a VLOOKUP to bring back the minimum value for a specific field. Currently I have two excel tabs, the first has all data with multiple variance values for each transaction number (All Data), the second tab (Filtered Data) has only transaction numbers (no duplicates) and a few other transaction detail fields. What I would like to do is complete a VLOOKUP (or any other method that would work) that matches the transaction number between the two tabs and returns the MIN value for variance for each transaction onto my 2nd tab next to the transaction number. Example is below:

All Data Tab:

Transaction Number / Variance
12345 / 0.982
12345 / 0.625
12345 / 1.051
12345 / 1.345
67890 / 0.370
67890 / 0.506
67890 / 0.125
67890 / 0.257


Filtered Data Tab:

Transaction Number / Variance (Min result returned from All Data tab)
12345 / 0.625
67890 / 0.125


Any help on how to do this would be great!!

[gak67]

The formula needs to be an array formula, which is confirmed with Ctrl+Shift+Enter, not just enter (this will put braces (the curly brackets) around the ends of the formula).

You have not given ranges, so hopefully this makes sense - replace the square brackets with the relevant ranges/references:
=MIN(IF([All Data transaction numbers]=[Filtered Data transaction number to lookup],[All Data variances]))

[ralldredge]

That worked! Than kyou so much for your help!!