We have data where team members are allotted for specific projects. Each resource has different availability, so while pulling the counts I want to multiply by the availability factor. I was thinking HLOOKUP, VLOOKUP and countif will help but not able to solve this completely. Attaching the spreadsheet. Can someone help me on this?Planning.xlsx