MATCH not working

[Mitchell14]

Hello experts,

I am in need of your names sake in the form of advice.

I am trying to simply MATCH two variables and bring back a value.

I have simplified my formula for this query and also simplified the document.

I am using the below formula entered with ctrl, shift and enter.

={(INDEX(Cleaning!$V$2:$V$4,MATCH(1,((Cleaning!$A$2:$A$4='NG Lost Unallocated Detail'!D2)*(Cleaning!$A$2:$A$4='NG Lost Unallocated Detail'!J2)),0)))}

I am fairly confident this formula is correct...

It is almost certainly the format that is not allowing the data to be matched, but i have tried TRIM, Text to comlumns and changed relevant columns to number format.

I am in diar need of some help as I am completely stumped.

It is simply looking up Month No and Employee number and should bring back weekly value.

I am unsure how to post the WB so any sugestions from the above will be much appreciated!

Tom

 

[Marcelo Branco]

I am using the below formula entered with ctrl, shift and enter.

={(INDEX(Cleaning!$V$2:$V$4,MATCH(1,((Cleaning!$A$2:$A$4='NG Lost Unallocated Detail'!D2)*(Cleaning!$A$2:$A$4='NG Lost Unallocated Detail'!J2)),0)))}

I am fairly confident this formula is correct...

Are you sure the ranges in red are correct?

The formula is testing if Cleaning!$A$2:$A$4
is equal to
'NG Lost Unallocated Detail'!D2
AND
is equal to
'NG Lost Unallocated Detail'!J2

It doesn't seem possible
(unless 'NG Lost Unallocated Detail'!D2 is equal to 'NG Lost Unallocated Detail'!J2. In this case the second condition is superfluous.)

M.

 

[Excelaron]

I think you have too many parenthesis ={INDEX(Cleaning!$V2$4,MATCH(1,(Cleaning!$A2$A4='NG Lost Unallocated Detail'!D2)*(Cleaning!$A2$A4='NG Lost Unallocated Detail'!J2),0))}