Find a lowest price for the specific SKU entered in to the text field.

Hello there. I have a project where I need to find a lowest price for the specific SKU entered in to the text field. I have 5 columns: SKU(ItemNumber), Itemtitle, Supplier1Price, Supplier2Price, Supplier3Price. Suppliers have their own prices. I want to make a button or something like that where I enter a SKU and it automatically finds the lowest price and shows it in the next cell with SupplierName



FOR EXAMPLE:

SKU Supplier1Price Supplier2Price Supplier3Price
12345 0.45 0.54 3

As you can see, Supplier1 has the lowest price. The code should automatically detect the lowest price and show it in the cell with the SupplierName (which is Supplier1Price in this case)

It would be easier to test possible solutions if you could attach a copy of your file. De-sensitize the data if necessary.

Please Login or Register  to view this content.

welcome to the forum

For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

As you are new to the board I did it for you this time

Insert a Button on your worksheet, and attach this code to the button

Please Login or Register  to view this content.