Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,))} |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,))} |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,))} |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,))} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data from Oracle to Excel | Excel Discussion (Misc queries) | |||
Excel VBA against Oracle | Excel Discussion (Misc queries) | |||
SQL for Oracle | Excel Discussion (Misc queries) | |||
SQL for Oracle | Excel Discussion (Misc queries) | |||
how do I import data from oracle version 7 to excel 2002 | Excel Discussion (Misc queries) |