...
Let's start with two simple tables. The first contains the engagement budget. The second contains project budgets. We'd like to get the engagement budget included in the second table.
Engagement Budget Table
| Engagement Code | Engagement Budget |
|---|---|
| P001000 | 100k |
| P001002 | 200k |
Project Budget Table
| Engagement Code | Project Code | Project Budget | Engagement Budget |
|---|---|---|---|
| P001000 | P001000-001 | 10k | ? |
| P001001 | P001001-001 | 11k | ? |
| P001002 | P001002-001 | 12k | ? |
Where you see the question marks, we are going to insert a formula. The formula will take the engagement code from the second table, look for it the first table, and then return the budget.
...
Project Budget Table (end result)
| Engagement Code | Project Code | Project Budget | Engagement Budget |
|---|---|---|---|
| P001000 | P001000-001 | 10k | 100k |
| P001001 | P001001-001 | 11k |
| P001002 | P001002-001 | 12k | 200k |
...