I'm trying to do something simple. I want to compare prices from different
vendors: Column A = vendor 1, Column 2 = vendor 2, etc.. All of them have
different prices I just want to create a seperate column that we equal the
lowest prices. If this can be done would be great. Then there is one other
added need: need the Manufacturers SKU to match. So first column man. sku for
vendor 1 then price in column 2 , then in column three man. sku for second
vendor and in column 4 their price, etc.. I need a function that will take if
all Man. SKU's that match and compare all vendors prices and put that into a
newley created column. Can someone help me or point me in the right
directions? Thanks.