Look Up Help

[markoakes]

In Row 1 starting in column D I have a list of Names going across to column X. Sales by day are list under each Name. In Column A go down I have Dates. In column B next to each date I need a formula that will find the Lowest Sales for that Dates Row and return the Name from above.

 

[T. Valko]

In Row 1 starting in column D I have a list of Names going across to column X. Sales by day are list under each Name. In Column A go down I have Dates. In column B next to each date I need a formula that will find the Lowest Sales for that Dates Row and return the Name from above.

Try this...

Entered in B2 and copied down as needed:

=INDEX(D$1:X$1,MATCH(MIN(D2:X2),D2:X2,0))

Note that if there are duplicate minimums on a row the formula will match the left-most instance.

 

[markoakes]

Worked Great, Thanks

 

[T. Valko]

Worked Great, Thanks

You're welcome. Thanks for the feedback!