Need formula for this
Can someone help me please with this in Excel 2010:
In the example of the attached picture:
Example with yellow cells: numbers in A1 and B1 to be detected on the columns E, F, I, J (cells A1 and B1 are always side by side in this way), then these two numbers to be displayed in the cell M3 plus the maximal of the numbers from the cells: C1, G2 and K4 (neighboring cells). The final text (cell M3) must look exactly like in the picture.
A couple questions: • How are
A couple questions:
• How are the items in column M ordered?
• Are the values in column A unique?
If the answer to the first question is that it doesn't matter, and the answer to the second question is yes, then:
=A1&";"&B1&";"&MAX(VLOOKUP(A1,E:G,3,FALSE),VLOOKUP(A1,I:K,3,FALSE),C1)