Index/Lookup formulae

Gaurav Chauhan
Gaurav Chauhan ✭✭✭✭✭✭

Hi Team, Can you please share what sort of Index and match formuale would we write to bring in the Project ID on the New sheet

The project name on the auto updated is a combination and can be searched and then corresponding project id needs to be populated