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,
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
Don’t have an account yet? Register yourself now and be a part of our community!