Hi All,
Hope you are having a good time!
I was trying to do some lookup through multiple tables but could not do it. Need some help here
I have a table from where i am trying to extract overall max value and then based off of some condition. There exits 1 more table with same header. Tables would be something as below-
<colgroup><col span="5"><col><col><col span="5"></colgroup><tbody>
</tbody>What I wanted to have is corresponding cell value from Table 2.
Thank you so much for your help,
Hari
Hope you are having a good time!
I was trying to do some lookup through multiple tables but could not do it. Need some help here
I have a table from where i am trying to extract overall max value and then based off of some condition. There exits 1 more table with same header. Tables would be something as below-
Table 1 | Table 2 | ||||||||||
A | B | C | D | E | A | B | C | D | E | ||
10 | 4 | 3 | 63 | 19 | Yes | Yes | No | No | No | ||
10 | 2 | 1 | 0 | 0 | No | No | No | No | Yes | ||
61 | 26 | 99 | 70 | 56 | Yes | Yes | Yes | Yes | No | ||
20 | 3 | 3 | 60 | 25 | No | No | No | Yes | Yes | ||
0 | 0 | 0 | 0 | 0 | No | Yes | Yes | Yes | Yes | ||
55 | 7 | 98 | 45 | 9 | No | No | No | No | No | ||
Max-Overall | 63 | ||||||||||
Table 2 corresponding cell value | ?? | ||||||||||
Max if Yes | 10 | ||||||||||
Table 2 corresponding cell value | ?? |
<colgroup><col span="5"><col><col><col span="5"></colgroup><tbody>
</tbody>
Thank you so much for your help,
Hari