Looking up Variable - finding min value / Header info

[crzytimes]

Good Morning Everyone I have a data dump out of my companies ERP system that I'm trying to efficiently manage. There are about 10,000 rows and roughly 60 columns in the export file every week. I'm trying to write a formula that looks up a specific value and then finds the minimum value in that row. Another formula will pull the header that the min value is in. I've attached a sample file and a screenshot to this post if anyone can help me out. I'm completely stumped right now and struggling to get the right thing going.

Sample File

 

[Fluff]

How about
=MIN(INDEX($G$2:$M$7,MATCH(A2,$F$2:$F$7,0),0))

 

[crzytimes]

How about
=MIN(INDEX($G$2:$M$7,MATCH(A2,$F$2:$F$7,0),0))

That is fantastic. I was working backwards and trying to stick my MIN function inside the Index / Match.

 

[Fluff]

You're welcome & thanks for the feedback

 

[crzytimes]

Also, with your original help, finding the column header was pretty easy. I should be able to transpose this into my ERP export pretty easily now.

Formula was

=INDEX($G$1:$M$1,0,MATCH(MIN(INDEX($G$2:$M$7,MATCH(A2,$F$2:$F$7,0),0)),(INDEX($G$2:$M$7,MATCH(A2,$F$2:$F$7,0),0)),0))

I'm going to convert it to named ranges a bit later on my master file so that it's easier for me to view again later

Thank you - Again

 

[Fluff]

Glad you were able to sort it.