If function with Index Match Returning #value

[aking3806]

Hi,

I have two worksheets that I am using and I want to automate the data entry process using an IF function and Index Match Match.

I used the following formula to link the sheets and to perform the lookup based on a criteria:

=IF($AF$4="Projected",INDEX('[WIN10_PTO Projections.xlsx]WORKSTREAM 1'!$B$1:$DO$16,MATCH($C$9,'[WIN10_PTO Projections.xlsx]WORKSTREAM 1'!$D$1:$D$16,0),MATCH(AF1,'[WIN10_PTO Projections.xlsx]WORKSTREAM 1'!$A$1:$DO$1,0),),0)

The first match of this formula returns a value without an error, however, when I add in the second match I get the #value error. I've tried entering it as an array formula but the same issue occurs. Can anyone advise?

Thanks!

[Special-K]

Remove the comma after the second MATCH like so

=IF($AF$4="Projected",INDEX('[WIN10_PTO Projections.xlsx]WORKSTREAM 1'!$B$1:$DO$16,MATCH($C$9,'[WIN10_PTO Projections.xlsx]WORKSTREAM 1'!$D$1:$D$16,0),MATCH(AF1,'[WIN10_PTO Projections.xlsx]WORKSTREAM 1'!$A$1:$DO$1,0)),0)