| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
prices
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prices
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prices
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prices
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel template to compare grocery prices at two or more stores | Setting up and Configuration of Excel | |||
| How do I tie prices to a drop down list of products in excel? | Excel Discussion (Misc queries) | |||
| Look up a list of prices | Excel Worksheet Functions | |||
| help with quote program using muliple prices for one quantity {cross post} | Excel Discussion (Misc queries) | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
Hybrid Mode
