# Search for minimum price with dynamic range and return price and product ref

1. ## Search for minimum price with dynamic range and return price and product ref

Good afternoon,

I would like some help with the following Excel problem:

There's a list of products. In the example worksheet attached there's 3 products: T-shirt 1, t-shirt 2 and t-shirt 3 (however, there could be other products such as Trouser 1). The products have different prices depending on small differences between them (e.g. T-shirt 1 may have the t-shirt logo in the inside either printed or stitched) and I would like to find the minimum price for each product (i.e. For t-shirt 1, for t-shirt 2 and for t-shirt 3).

The problem I find is that in reality there are many more products, so the range should be dynamic (there may be three t-shirt 1s and 15 t-shirt 4s).

Additionally, if the price is exactly the same, I would like the summary table to return the t-shirt reference with the lowest minimum purchase requirements.

Best,

gjrr4x1

2. ## Re: Search for minimum price with dynamic range and return price and product ref

You can put this array* formula in H5:

Formula:
`Please Login or Register  to view this content.`

and this array* formula in I5:

Formula:
`Please Login or Register  to view this content.`

and then copy the formulae down.

* An array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual <Enter>. If you do this correctly, then Excel will wrap curly braces { } around the formula when viewed in the formula bar, but you should not type these yourself. If you need to edit the formula subsequently then you will need to use CSE again. You can copy/paste an array formula in the normal way(s).

Hope this helps.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1