S
Steved
Hello from Steved
The Below Is giving me a #VALUE! What is required please to give me a result.
I need to use 2 columns in each worksheet to get a result.
Index B4:C4 "In current worksheet"
Match $C$2:$D$5000 in ""Duties Mon-Fri Worksheet""
Result $B$2:$B5000 in "Duties Mon-Fri Worksheet"
=INDEX('Duties Mon-Fri'!$B$2:$B5000,MATCH(B4:C4,'Duties
Mon-Fri'!$C$2:$D$5000,0))
Current Worksheet contains the values
Col B:B and C:C
8431 and 510
Duties Mon-Fri Worksheet contains the values
Col C:C and D
8431 and 510
The result is in COL B:B in Duties Mon-Fri Worksheet
The result should be 4301 but it gives me #VALUE!
Thankyou.
The Below Is giving me a #VALUE! What is required please to give me a result.
I need to use 2 columns in each worksheet to get a result.
Index B4:C4 "In current worksheet"
Match $C$2:$D$5000 in ""Duties Mon-Fri Worksheet""
Result $B$2:$B5000 in "Duties Mon-Fri Worksheet"
=INDEX('Duties Mon-Fri'!$B$2:$B5000,MATCH(B4:C4,'Duties
Mon-Fri'!$C$2:$D$5000,0))
Current Worksheet contains the values
Col B:B and C:C
8431 and 510
Duties Mon-Fri Worksheet contains the values
Col C:C and D
8431 and 510
The result is in COL B:B in Duties Mon-Fri Worksheet
The result should be 4301 but it gives me #VALUE!
Thankyou.