Hi,
There are a lot of INDEX/MATCH/VLOOKUP examples out there but I could not find the one that I need.
I want the following:
I have 2 tables,
table 1:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
and table 2 (the # and the @ are normally not there, it is for this example):
<tbody style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: 100%; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I need to have a formula in table 2 to find the value in the totals column in table 1 by using the colum names and the row names in table 2.
In this example, a 5 should be where the # is (there is a C2 in table 1) and if there is no simularity in table 1 it should not return anything like for example the @ (there is no A2 in table 1).
I hope I am clear enough for someone to help me out.
Regards,
Raoul
There are a lot of INDEX/MATCH/VLOOKUP examples out there but I could not find the one that I need.
I want the following:
I have 2 tables,
table 1:
Project | Code | Totals |
C | 1 | 10 |
C | 2 | 5 |
C | 3 | 0 |
D | 2 | 7 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
and table 2 (the # and the @ are normally not there, it is for this example):
Code |
<tbody style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: 100%; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">
</tbody>
Project | 1 | 2 |
C | # | |
A | @ | |
C | ||
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I need to have a formula in table 2 to find the value in the totals column in table 1 by using the colum names and the row names in table 2.
In this example, a 5 should be where the # is (there is a C2 in table 1) and if there is no simularity in table 1 it should not return anything like for example the @ (there is no A2 in table 1).
I hope I am clear enough for someone to help me out.
Regards,
Raoul