Array funciton Index and Match Issue

[VinayShankam]

I've used an array function with Index and Match Issue and it works on 3 tabs (QA Start, QA Pass, Soft Launch ) but not the fourth tab (Hard Launch). On the 4th tab I get a #VALUE! error.

I've done 'Evaluate Formula' and isolated the problem to this IF condition IF('Master Schedule'!$N$2:$N$200,"=",
But it is the same IF condition I have used in the 3 tabs (QA Start, QA Pass, Soft Launch ) so not sure what the issue is

URL to the file https://www.dropbox.com/s/1aszvsohjuaq3r1/Next 4 Week Commits.xlsx

Please could you help troubleshoot

 

[wigi]

Hi

Cell N132 on the Master Schedule is the culprit.
Why having both dates and text in the same column? Your formula expects a number or a true/false result,
while you supply cells with text. That's not going to work like that and is bad spreadsheet design.

 

[Aladin Akyurek]

I've used an array function with Index and Match Issue and it works on 3 tabs (QA Start, QA Pass, Soft Launch ) but not the fourth tab (Hard Launch). On the 4th tab I get a #VALUE! error.

I've done 'Evaluate Formula' and isolated the problem to this IF condition IF('Master Schedule'!$N$2:$N$200,"=",
But it is the same IF condition I have used in the 3 tabs (QA Start, QA Pass, Soft Launch ) so not sure what the issue is

URL to the file https://www.dropbox.com/s/1aszvsohjuaq3r1/Next%204%20Week%20Commits.xlsx

Please could you help troubleshoot

Care to explain what "=" means as it appears there in the formula?

 

[VinayShankam]

It seems to work in 3 other tabs, but not the fourth one...so it a little curious

 

[Aladin Akyurek]

It seems to work in 3 other tabs, but not the fourth one...so it a little curious

I don't think that "=" usage is correct, so it would help if you could wat it stans for