Oracle import
 

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,))}

Oracle import
 

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,))}

Oracle import
 

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,))}

Oracle import
 

Hello Max

Thankyou for your solution "Yes much Better"

Steved

"Max" wrote:

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,))}