find store

[Lafayettehunting]

Ok I’m using excel 07<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have one cell finding the lowest price in multiple cells this is my formula..<o></o>
"=MIN(H6,M6,W6,AA6,AF6"<o></o>
Now I need another cell to look at the cell that contains the lowest price<o></o>
And find the name of the store that has that price<o></o>
The cell are in "D5,I5,N5,S5,X5,AB5"<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="WIDTH: 12pt; HEIGHT: 15.75pt; VISIBILITY: visible; mso-wrap-style: square" id=Picture_x0020_1 alt="0" type="#_x0000_t75" o:spid="_x0000_i1025"><v:imagedata o:title="0" src="file:///C:\Users\rwhitus\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif"></v:imagedata></v:shape><o></o>

 

[number kruncher]

As you have 5 values to check for min value and 6 possible stores, this will need to be equal 5 and 5 or 6 and 6.

Then you can use an INDEX and MATCH, eg..

=INDEX(store-range,match(min-value,min-range,false))

HTH

 

[T. Valko]

Ok I’m using excel 07<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have one cell finding the lowest price in multiple cells this is my formula..<o></o>
"=MIN(H6,M6,W6,AA6,AF6"<o></o>
Now I need another cell to look at the cell that contains the lowest price<o></o>
And find the name of the store that has that price<o></o>
The cell are in "D5,I5,N5,S5,X5,AB5"<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></vath><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype><v:shape id=Picture_x0020_1 style="VISIBILITY: visible; WIDTH: 12pt; HEIGHT: 15.75pt; mso-wrap-style: square" type="#_x0000_t75" o:spid="_x0000_i1025" alt="0"><v:imagedata src="file:///C:\Users\rwhitus\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif" o:title="0"></v:imagedata></v:shape><o></o>

You have 5 cells in the MIN function but you have 6 cells that you want to look in for the store name.

The cells for the price are not equally spaced so this may require a long nested IF function!

 

[Lafayettehunting]

OK
THIS

Ok I’m using excel 07<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have one cell finding the lowest price in multiple cells this is my formula..<o></o>
"=MIN(H6,M6,R6,W6,AA6,AF6"<o></o>
Now I need another cell to look at the cell that contains the lowest price<o></o>
And find the name of the store that has that price<o></o>
The cell are in "D5,I5,N5,S5,X5,AB5"<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></vath><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype><v:shape style="WIDTH: 12pt; HEIGHT: 15.75pt; VISIBILITY: visible; mso-wrap-style: square" id=Picture_x0020_1 o:spid="_x0000_i1025" type="#_x0000_t75" alt="0"><v:imagedata src="file:///C:\Users\rwhitus\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif" o:title="0"></v:imagedata></v:shape><o></o>

 

[number kruncher]

Ok, try

=INDEX(D5:AB5,match(MIN(H6,M6,R6,W6,AA6,AF6),H6:AF6,false))

HTH

 

[Lafayettehunting]

OK
THIS

Ok I’m using excel 07<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have one cell finding the lowest price in multiple cells this is my formula..<o></o>
"=MIN(H6,M6,R6,W6,AA6,AF6"<o></o>
Now I need another cell to look at the cell that contains the lowest price<o></o>
And find the name of the store that has that price<o></o>
The cell are in "D5,I5,N5,S5,X5,AB5"<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></vath><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype><v:shape style="WIDTH: 12pt; HEIGHT: 15.75pt; VISIBILITY: visible; mso-wrap-style: square" id=Picture_x0020_1 o:spid="_x0000_i1025" type="#_x0000_t75" alt="0"><v:imagedata src="file:///C:\Users\rwhitus\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif" o:title="0"></v:imagedata></v:shape><o></o>

That found the cell above ,but i made it work, thanks
but
"=MIN(H6,M6,R6,W6,AA6,AF6" this formula is in C6
I would like to use cell B6 to find the value from C6 and then find the store name in
cells "D5,I5,N5,S5,X5,AB5"<v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> </v:shapetype>

 

[T. Valko]

OK
THIS

Ok I’m using excel 07<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have one cell finding the lowest price in multiple cells this is my formula..<o></o>
"=MIN(H6,M6,R6,W6,AA6,AF6"<o></o>
Now I need another cell to look at the cell that contains the lowest price<o></o>
And find the name of the store that has that price<o></o>
The cell are in "D5,I5,N5,S5,X5,AB5"<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></vath><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype><v:shape id=Picture_x0020_1 style="VISIBILITY: visible; WIDTH: 12pt; HEIGHT: 15.75pt; mso-wrap-style: square" type="#_x0000_t75" o:spid="_x0000_i1025" alt="0"><v:imagedata src="file:///C:\Users\rwhitus\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif" o:title="0"></v:imagedata></v:shape><o></o>

That found the cell above ,but i made it work, thanks
but
"=MIN(H6,M6,R6,W6,AA6,AF6" this formula is in C6
I would like to use cell B6 to find the value from C6 and then find the store name in
cells "D5,I5,N5,S5,X5,AB5"<v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> </v:shapetype>

You want the minimum value from these cells:

H6,M6,R6,W6,AA6,AF6

Are there any numeric values in the cells between those cells?

Those cells are equally spaced at 5 cells except from W6 to AA6 which is 4 cells.

 

[Lafayettehunting]

I have a spread sheet with the following<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Column A is for a list (names)<o></o>
Column B row 6 is to find what’s in C6<o></o>
Column C row 6 is looking for the lowest price in H6:AG6 (=MIN(H6,R6,W6,AB6,AG6)<o></o>
D5 E5 F5 G5 H5<o></o>
Columns D5:AG5 has text (Sam's,LBS,OZ,Quantity,Each and so on<o></o>
Columns D6:AG6 has numbers<o></o>
I need B6 to look at C6 that found the lowest price and also find the store that had the lowest price (C6) <o></o>
these are in D5,I5,N5,S5,X5,AC5 and return that store name in B6<o></o>
<o></o>

 

[T. Valko]

I have a spread sheet with the following<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Column A is for a list (names)<o></o>
Column B row 6 is to find what’s in C6<o></o>
Column C row 6 is looking for the lowest price in H6:AG6 (=MIN(H6,R6,W6,AB6,AG6)<o></o>
D5 E5 F5 G5 H5<o></o>
Columns D5:AG5 has text (Sam's,LBS,OZ,Quantity,Each and so on<o></o>
Columns D6:AG6 has numbers<o></o>
I need B6 to look at C6 that found the lowest price and also find the store that had the lowest price (C6) <o></o>
these are in D5,I5,N5,S5,X5,AC5 and return that store name in B6<o></o>
<o></o>

You keep changing the cells addresses of where your data is located.

Maybe someone else can help you.

Good luck!

 

[Lafayettehunting]

ok thanks
I fixed the cells that where missing and was trying to give some better info of the whole sheet

This formula below worked ,this found the store name but it takes up two rows in column B row 6

=INDEX(D5:AB5,match(MIN(H6,M6,R6,W6,AA6,AF6),H6:AF6,false))