Hi all,
I am trying to find a way to calculate a value using parameters stored in different sheets/tables. I have been trying to do this with sum and vlookup without success. The input data looks like this:
<tbody>
</tbody>
and
<tbody>
</tbody>
For each line in the first table I would like to calculate
=IF(Power>0;VLOOKUP(Table1!Type;Table2;2;FALSE)*2^Table1!Power;0)
I am able to calculate this for each line, but I need to calculate the sum of this value for all the lines in a single cell.
All my attempts with VLOOKUP have so far met with failure. Any help is greatly appreciated!!
Thanks in advance!
I am trying to find a way to calculate a value using parameters stored in different sheets/tables. I have been trying to do this with sum and vlookup without success. The input data looks like this:
| Type | Power |
| A | 5 |
| A | 9 |
| B | 0 |
| B | 1 |
| C | 6 |
| C | 2 |
| C | 3 |
| D | 7 |
| D | 0 |
| D | 0 |
<tbody>
</tbody>
and
| Type | Base |
| A | 3 |
| B | 3 |
| C | 4 |
| D | 5 |
<tbody>
</tbody>
For each line in the first table I would like to calculate
=IF(Power>0;VLOOKUP(Table1!Type;Table2;2;FALSE)*2^Table1!Power;0)
I am able to calculate this for each line, but I need to calculate the sum of this value for all the lines in a single cell.
All my attempts with VLOOKUP have so far met with failure. Any help is greatly appreciated!!
Thanks in advance!
