Vlook up with highest of multiple sources

[espsun]

Hi,

I am trying to build a pricing calculator based on our productions. I want to be able to fill in the article code, and return the highest of multiple production cost should appear in the material cost.
When I use the MAX function I do not know how to combine this when I have two sources to vlookup. Any ideas?

 

[Joe4]

Welcome to the Board!

You can use IF formula with MAX in an array formula, as shown here: Excel formula: Max if criteria match | Exceljet

 

[Fluff]

As you have xl365 you could also use the MAXIFS function How to use the Excel MAXIFS function | Exceljet