Hi, I'm having Excel issues and I'm stranded after multiple hours of googling.
Question:
How can I perform a VLOOKUP when the value is included in several rows (I want the highest number)
Context:
I have one overview where I wish list to various type of Information. This information have certain numerical criterias, which i named "LEVEL A", "LEVEL B" and "LEVEL C"
NOTE: The main thing here is that I have a Data-validation on "Included in System", which makes me get a drop-down list selection of various sheets. I have also added a VBA which make it possible for me to Select more than one item from the drop-down list.
The Second overview is the system, and I want the system to inherit the highest value from the Information sheet
--> e.g.: Information #2 is included in System #1 , #2 and #3 . How do i then get the System overview to show the highest value from the Information Valuation sheet?
--> I tried doing a MAX formula combined With VLOOKUP, but this only grants me the highest number of the first information that includes the specific system.
<tbody>
</tbody>
Which formula can I use to get this data?
<tbody>
</tbody>
Question:
How can I perform a VLOOKUP when the value is included in several rows (I want the highest number)
Context:
I have one overview where I wish list to various type of Information. This information have certain numerical criterias, which i named "LEVEL A", "LEVEL B" and "LEVEL C"
NOTE: The main thing here is that I have a Data-validation on "Included in System", which makes me get a drop-down list selection of various sheets. I have also added a VBA which make it possible for me to Select more than one item from the drop-down list.
The Second overview is the system, and I want the system to inherit the highest value from the Information sheet
--> e.g.: Information #2 is included in System #1 , #2 and #3 . How do i then get the System overview to show the highest value from the Information Valuation sheet?
--> I tried doing a MAX formula combined With VLOOKUP, but this only grants me the highest number of the first information that includes the specific system.
So to summary, I have this data:
Information | A | B | C | Included in system |
Information1 | 1 | 2 | 3 | System1 |
Information2 | 2 | 2 | 2 | System1, System2, System3 |
Information3 | 4 | 4 | 4 | System3 |
<tbody>
</tbody>
Which formula can I use to get this data?
System | A (Max) | B (Max) | C (Max) |
System1 | 2 | 2 | 2 |
System2 | 2 | 2 | 2 |
System3 | 4 | 4 | 4 |
<tbody>
</tbody>
Last edited by a moderator: