Reply to thread

Message: [QUOTE="JLatham, post: 3225023"] Try a variation of this: =IF(AND(A2<B2,A2<C2),"Bakers",IF(AND(B2<A2,B2<C2),"Costco","Walmart")) change references to A2 to the column with Bakers costs in it, change references to B2 to column with Costco prices, and change references to C2 to column with Walmart prices. I believe that'll do the trick for you. Now if all prices are equal - you will get sent to Walmart - so you might want to rearrange things so that the closest outlet ends up being the "default when all prices are equal" :-). [/QUOTE]