Index Match with 3 criteria

Santiagogr1

I want to use the indexMatch formula to get data in the [Column 1], the columns that have to match in the other sheet ([Sheet 2]) are [Project Number], [# Division] and [# Bundle].

I have been trying using the AI formula generator and it gave me this formula:

=INDEX({Range Sheet2}, MATCH([Project Number]@row & [# Division]@row & [# Bundle]@row, {Sheet2 Project Number} & {Sheet2 Division} &({Sheet2 Bundle}, 1))

however, it shows "#UNPARSEABLE"..

Can someone help me with this.

Paul Newcome

You would use an INDEX/COLLECT instead:

=INDEX(COLLECT({Range Sheet2}, {Sheet2 Project Number}, @cell = [Project Number]@row, {Sheet2 Division}, @cell = [# Division]@row, {Sheet2 Bundle}, @cell = [# Bundle]@row), 1)