Hi everyone,
I was wondering if you could please help me. I have two tables on that I want to present information (table 1) and the other that lists the data (table 2). Table one shows the area, sub area and item and I would like to create a formula in the item code column that returns the appropriate value from table 2 based on the criteria of item and sub area.
My problem is that I have basic knowledge of index and match functions and cannot seem to create a way to look up a column that is unknown.
Thank you for your help.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
I was wondering if you could please help me. I have two tables on that I want to present information (table 1) and the other that lists the data (table 2). Table one shows the area, sub area and item and I would like to create a formula in the item code column that returns the appropriate value from table 2 based on the criteria of item and sub area.
My problem is that I have basic knowledge of index and match functions and cannot seem to create a way to look up a column that is unknown.
- Could you please help me to create a forumla that is able to look across to find the appropriate column and then down to find the approproate item and then return the item code?
- Is there a way to do the above if I have each sub area on a separate tab?
Thank you for your help.
Table 1
| Area | Area Code | Sub Area | Sub Area Code | Item | Item Code |
| Finance | 006-02-08 | Accounting | 006-02-08-001 | Training | |
| HR | 006-02-06 | Recruiting | 006-02-06-003 | Vacation |
<tbody>
</tbody>
Table 2
| Accounting | 006-02-08-001 | Recruiting | 006-02-06-003 |
| Training | 006-02-08-001-004 | Personnel | 006-02-06-003-001 |
| Computers | 006-02-08-001-005 | Rellocation | 006-02-06-003-002 |
| Operating Costs | 006-02-08-001-006 | Vacation | 006-02-06-003-003 |
<tbody>
</tbody>
