MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Price Comparison formula

• Follow

```  Acme 	XXX Price   OOO Price	  Best Price
\$46.21 	\$49.95 	\$46.21

I am looking to create a formula that will compare the three prices listed
and enter the lowest price header into the "best price" column.

```
 0

```Hi,

=MIN(B6:D6)

change range to fit your needs

if this helps please click yes thanks

"TJC" wrote:

>   Acme 	XXX Price   OOO Price	  Best Price
>  \$46.21 	\$49.95 	\$46.21
>
> I am looking to create a formula that will compare the three prices listed
> and enter the lowest price header into the "best price" column.
>
```
 0

```Thanks, I tried this, but am actually looking to have the Best Price column
reflect the vendor name rather than the "best price".  Thanks again for your
help!

"Eduardo" wrote:

> Hi,
>
> =MIN(B6:D6)
>
> change range to fit your needs
>
> if this helps please click yes thanks
>
> "TJC" wrote:
>
> >   Acme 	XXX Price    OOO Price       Best Price
> >  \$46.21 	\$49.95 	  \$56.21             Acme
> >
> > I am looking to create a formula that will compare the three prices listed
> > and enter the lowest price header into the "best price" column.
> >
```
 0

```On Wed, 18 Nov 2009 10:56:01 -0800, TJC
<TJC@discussions.microsoft.com> wrote:

>  Acme 	XXX Price   OOO Price	  Best Price
> \$46.21 	\$49.95 	\$46.21
>
>I am looking to create a formula that will compare the three prices listed
>and enter the lowest price header into the "best price" column.

First, make sure that the prices are numbers formatted as currency and
not text. Then you may try the following formula:

=INDEX(A1:C1,,MATCH(MIN(A2:C2),A2:C2,0))

This will list the header with corresponding to the lowest price.
If there are more than one header with the lowest price, as in your
example, the leftmost of them will be listed

Hope this helps / Lars-�ke

```
 0

```Hi, try

=IF(MIN(B6:D6)=B6,\$B\$5,IF(MIN(B6:D6)=C6,\$C\$5,\$D\$5))

I assume that your names are in row 5

"TJC" wrote:

> Thanks, I tried this, but am actually looking to have the Best Price column
> reflect the vendor name rather than the "best price".  Thanks again for your
> help!
>
> "Eduardo" wrote:
>
> > Hi,
> >
> > =MIN(B6:D6)
> >
> > change range to fit your needs
> >
> > if this helps please click yes thanks
> >
> > "TJC" wrote:
> >
> > >   Acme 	XXX Price    OOO Price       Best Price
> > >  \$46.21 	\$49.95 	  \$56.21             Acme
> > >
> > > I am looking to create a formula that will compare the three prices listed
> > > and enter the lowest price header into the "best price" column.
> > >
```
 0

```With "Acme" in a1 and prices in a2:c2.
=INDEX(A1:C1,1,MATCH(MIN(A2:C2),A2:C2,0))

Will get the job done.

"TJC" wrote:

>   Acme 	XXX Price   OOO Price	  Best Price
>  \$46.21 	\$49.95 	\$46.21
>
> I am looking to create a formula that will compare the three prices listed
> and enter the lowest price header into the "best price" column.
>
```
 0

5 Replies
726 Views

Similiar Articles:

7/23/2012 12:57:21 PM