Use one column for function and return a value of another?

[farmerTom]

I'm really new to Excel, and don't have even a basic grasp yet. So please forgive me if I can't even phrase the question right.

I'm trying to make a lottery spreadsheet so I can analyze the numbers in a simple way......

What I'm trying to do here is to select the min number picked but I want to return the actual number not the number of times it was picked.


=MIN(U1:U35) here's the function I used to find the smallest number in this column, but I want to display the number from column "N" as a return....

See image below>


http://server6.theimagehosting.com/i...Hunter_008.jpg

[Paul]

Try this formula in cell V2:

=INDEX($N$1:$N$35,MATCH(MIN($U$1:$U$35),$U$1:$U$35,0))

Note: If two or more values have the same minimum in column U, this will only pull the first one it encounters.

[farmerTom]

Try this formula in cell V2:

=INDEX($N$1:$N$35,MATCH(MIN($U$1:$U$35),$U$1:$U$35,0))

Note: If two or more values have the same minimum in column U, this will only pull the first one it encounters.

That worked thank you!
When I'm a little farther along with this I'll post the spread sheet for others to use and improve on. This sheet is for the Pick 5 game in AZ. The game is composed of 5 numbers with a range of 1 - 35.

Tom

[Paul]

You're welcome. I lived in Phoenix for 8 years before moving to WI. Hope you're enjoying the heat, because we sure don't have any. (It snowed just a few days ago!)

[farmerTom]

You're welcome. I lived in Phoenix for 8 years before moving to WI. Hope you're enjoying the heat, because we sure don't have any. (It snowed just a few days ago!)

When I first moved back to Phoenix 12 years ago it was like sticking my head in an oven.....now if the temp drops below 70 I'm freezing to death. The perfect temp for me now is between 80 and 110. Anything outside that range is uncomfortable.