Hello from Steved

from this $B$2:$B$60000
to this $B$2:$B$60000+0

Yes it was treating it as text.

Thankyou.

"Steved" wrote:

Hello from Steved

If I have a 4 Digit the below "Formula" works as it should.

Excel shows "141" as 141 in Formula Bar but the Oracle Import shows it as
0141 in the Formula Bar

"Oracle import" is in sheet named "Duties Mon-Fri"

Please What do I Need to do for the Formula below to accept either to
function Thankyou.

{=INDEX('Duties Mon-Fri '!$F$2:$F$60000,MATCH(B6 &CHAR(1) &C6,'Duties
Mon-Fri '!$B$2:$B$60000 & CHAR(1) &'Duties Mon-Fri '!$G$2:$G$60000,))}