Instead of eg: =match(a1,..)
Try it like this: =match(text(a1,"0000"),..)
which will pad a leading zero to the number in A1 as required, besides
converting it to text as well, for consistency in matching
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Steved" wrote:
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,))}