Hey, so i’m relatively new to excel.

i have a excel chart looking like this:

 10mm20mm30mm40mm0.1Pa5 kW6 kW7 kW8 kW0.2Pa9 kW10 kW11 kW12 kW0.3Pa13 kW14 kW15 kW16 kW

now i want to search a kW value out of this chart(10kW for example) and excel should show me the corresponding mm and Pa. (20mm/0,2Pa). The SI units are included via textformat.

I’ve tried to do my best with x/vlookup(=XVERWEIS(M17;J2:J20;A2:A20)), but excel only accepts one row/line to search.

Is there a good way or do i need multiple vlookups in an if/else configuration to search every line/row?

​Hey, so i’m relatively new to excel. i have a excel chart looking like this: 10mm20mm30mm40mm0.1Pa5 kW6 kW7 kW8 kW0.2Pa9 kW10 kW11 kW12 kW0.3Pa13 kW14 kW15 kW16 kW now i want to search a kW value out of this chart(10kW for example) and excel should show me the corresponding mm and Pa. (20mm/0,2Pa). The SI units are included via textformat.I’ve tried to do my best with x/vlookup(=XVERWEIS(M17;J2:J20;A2:A20)), but excel only accepts one row/line to search.Is there a good way or do i need multiple vlookups in an if/else configuration to search every line/row?    Read More

​