Hi All,
I have a huge dataset and need to find a specific value. Column A list all projects (active and completed) with resource type used for that project. Not all projects used the 3 types of resources so there isn't a pattern to go by except that resources are listed after each project. Column B lists dollar value for each resource. Using the example below, I want to know what Materials cost for Project2 and the answer should be 30. Any formula suggestions?
Col A Col B
Project-1
Travel $5
Personnel $100
Materials $25
Project-2
Travel $6
Materials $30
Project-3
Personnel $200
Project-4
Materials $100
Thanks in advance!!
Bookmarks