Mitchell14
New Member
- Joined
- Apr 9, 2014
- Messages
- 1
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
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