This is a discussion on Vlookup Lowest value...? within the Excel Questions forums, part of the Question Forums category; Hi Guys, hopefully an easy question for you. I have a list of town names (col A) and a list ...
Hi Guys, hopefully an easy question for you.
I have a list of town names (col A) and a list of figures (col B). they are random but what I would like to do is take out the lowest figure from column B against the town name.
Col A Col B
I have the town name, once, in another sheet and was thinking of doing a vlookup but to only bring the lowest number out. So for London, it would bring back '12'
Hope thats enough info.
Try something like: =MIN(IF(Sheet1!A1:A10=A1,Sheet1!B1:B10))
Confirmed with Ctrl+Shift+Enter as it's an array formula.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
- Guidelines For Posting
- Mr Excel Articles and PodCasts
- Display sheet using HTML Maker or Excel Jeanie
- Something that makes me laugh
- Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).
Please test any code on a copy of your workbook.