How to choose "worst" value

[Pakastin]

I have an offer sheet where according item code (column A) I get product group (A, B, C and D where A is best and D is worst) to column L with VLOOKUP. Let's say cells L1 to L4 are A, B, C and D, I should be able to get worst product group value brought to cell K1.

What would be the most straight forward way to do this?

I hope you get what I am looking for!

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Pakastin]

Attached very raw example of quotation and product categories. What I should get is, that if offer includes for example D category products, the total delivery time for complete offer is according D category.

[davsth]

As an array (shift control enter)


=MIN(CODE(D4:D7))-64&" weeks"

or also as an array

=INDEX(H4:H7,MIN(CODE(D4:D7))-64)