so the manufacturers sku is different for each vendor?Do you have a table
where say a product is listed by you in a row with the different
manufacturere sku and respective vendors in the repective columns?If that is
so do you have your own description or name for each product that you search
for ?
--
paul
remove nospam for email addy!



"Manager that needs help" wrote:

I organize everything by Manufacturer SKu. I just started learning Excel (I
like access better). Could you put me in a dummy step-by-step directions.

"paul" wrote:

i think a vlookup table or index match would work ,with a min formula at the
right.It depends how your data is organised.How do you "search" for
products?Do you have a name, description or do you search by any one of the
manufacturers SKU #
--
paul
remove nospam for email addy!



"Manager that needs help" wrote:

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.