I have a table with data as below.
Code aaa has a cost of $200 allocated to it
Code bbb has a cost of $500 allocated to it
| Code | Cost Allocation |
|---|---|
| aaa;bbb | 200;500 |
| ccc | 600 |
On another sheet, I would like to lookup the cost based on the code.
For code ccc I can use Sumproduct to find the cost = 500. But for code aaa and bbb, which excel function can I use to find the cost?
Column A Column B
Code Cost
ccc 600
aaa 200
bbb 500
I tried Sumproduct to find cost for code ccc. But for code bbb and ccc, I could not find a way to achieve the same result.
New contributor
Ryan Nguyen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.