Index/Lookup formulae

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

Mike TV

@Gaurav Chauhan

=INDEX(COLLECT({Project ID Column Sheet 1}, {Project Name Column Sheet1}, CONTAINS([Project Name]@row, @cell)), 1)

Gaurav Chauhan

Thank you. I should have named the columns differently. Just re-named them.

So based on your recommendation - =INDEX(COLLECT({Project ID Column Sheet 1}, {Project Name Column Sheet1}, CONTAINS([Project Name]@row, @cell)), 1)

the formulae would read as =INDEX(COLLECT({ID}, {Project}, CONTAINS([Shirt]), 1)

Mike TV

@Gaurav Chauhan

Almost. I believe this would be what you need based on your examples above:

=INDEX(COLLECT({ID}, {Project}, CONTAINS([Project Name]@row, @cell)), 1)