Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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,))} |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |