I would like to display the value of the third column of a table, which is determined by using two search criteria. The table in which is searched consists of three columns.
- The first column contains the names of the players.
- The second column contains the names of the unit.
- The third column contains the power for the players unit.
Example:
| Player | Unit | power |
|---|---|---|
| Bob | Magmatrooper | 19020 |
| Bob | Cad Bane | 24250 |
| Bob | TIE Fighter Pilot | 22657 |
| Bob | Grand Master Yoda | 27979 |
| Bob | Shaak Ti | 32988 |
...
| Player | Unit | power |
|---|---|---|
| Nik | Magmatrooper | 19020 |
| Nik | Cad Bane | 21400 |
| Nik | TIE Fighter Pilot | 17899 |
| Nik | Grand Master Yoda | 23400 |
| Nik | Shaak Ti | 29800 |
My approach: translate an Excel formula to google sheets.
In an Excel spreadsheet, the formula works as shown in Figure 1.
