Hello Everyone,
I wanted to ask your help regarding an excel matter, currently i have two tables having different formats,
i need to lookup the data in the first table from the data in the second table based on 3 criteria, the two tables are very big and have alot of data so i will just put here simpler tables as an example:
Table 1(the one need to be filled):
Table 2(The one which contains the data):
The numbers in the table are just for example.
so the criteria here is the site name and the Info and the Sector ID, and we should return the value corresponding to them, i tried several times but i failed to find a solution so i'm seeking your help, i hope you can help me.
Thanks in advance.
I wanted to ask your help regarding an excel matter, currently i have two tables having different formats,
i need to lookup the data in the first table from the data in the second table based on 3 criteria, the two tables are very big and have alot of data so i will just put here simpler tables as an example:
Table 1(the one need to be filled):
Site Name | Sector ID | Info 1 | Info 2 | Info 3 |
x | Sector 1 | |||
x | Sector 2 | |||
x | Sector 3 | |||
y | Sector 1 | |||
y | Sector 2 | |||
y | Sector 3 | |||
z | Sector 1 | |||
z | Sector 2 | |||
z | Sector 3 |
Table 2(The one which contains the data):
Sector 1 | Sector 1 | Sector 1 | Sector 2 | Sector 2 | Sector 2 | Sector 3 | Sector 3 | Sector 3 | |
Site Name | Info 3 | Info 1 | Info 2 | Info 3 | Info 1 | Info 2 | Info 3 | Info 1 | Info 2 |
x | 1 | 4 | 7 | 10 | 13 | 16 | 19 | 22 | 25 |
y | 2 | 5 | 8 | 11 | 14 | 17 | 20 | 23 | 26 |
z | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 |
The numbers in the table are just for example.
so the criteria here is the site name and the Info and the Sector ID, and we should return the value corresponding to them, i tried several times but i failed to find a solution so i'm seeking your help, i hope you can help me.
Thanks in advance.