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: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.