• Hi,

Im trying to find a lowest price and have the vendor listed on the side...

ex:
item vendor 1 vendor 2 vendor 3 etc..
gum \$2 \$3 \$4 etc..

i did "=min()" to find the lowest price but what function do i use to list the vendor's name next to it? :no:

• Hi tDk

Assuming you data resides in the range A1:B100

If the vendors name is the the right of the prices, use;

=VLOOKUP(MIN(\$A\$1:\$A\$100),\$A\$1:\$B\$100,2,FALSE)

If to the left, use;

=INDEX(\$A\$1:\$B\$100,MATCH(MIN(\$B\$1:\$B\$100),\$B\$1:\$B\$100,0),1)

• The secound index i like it very much , Because i most of the time chnage my data because to use vlookup.

Now i will not change my data to , My i feel bad to avoiding to use vlookup.

I am sorry vlookup.

-------------------------

I want to know is it possible to sort the data in formula.

suresh 300
elisha 100
oliver 250

after useing my formula i want the out put.( sort on value useing formula )

elisha 100
oliver 250
suresh 300
-----------------------

thanks

• Aladin Akyurek gave me this formula:

=INDEX(\$B\$1:\$D\$1,MATCH(MIN(B2:D2),B2:D2,0))

where \$B\$1:\$D\$1 is the range of cells containing vendor names and B2:D2 is the range with the prices