| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulae required
Hi,
I have range of data from which i want to copy data of a column to another range. There is a column in both ranges in which first 4 digits are same. A B C Date Title TC Time 01/12/2006 0489NEROLAC PAIN #N/A 01/12/2006 0490NEROLAC PAIN 01/12/2006 0491NEROLAC PAIN 01/12/2006 0492NEROLAC PAIN 01/12/2006 0493NEROLAC PAIN 01/12/2006 0494NEROLAC PAIN 01/12/2006 0495NEROLAC PAIN 01/12/2006 0496NEROLAC PAIN 01/12/2006 0497NEROLAC PAIN E F G Date TC Time Title 01/12/2006 22:59:01 0489Grasim Ind-P 01/12/2006 22:59:16 0490PADMINI-Elec 01/12/2006 22:59:26 0491SWASTIK INVE 01/12/2006 22:59:36 0492Sharman Shaw 01/12/2006 22:59:46 0493Shree Cement 01/12/2006 22:59:51 0494CTC MALL-OPT 01/12/2006 23:19:01 0495Swagat Bania 01/12/2006 23:19:11 0496EVEREST MASA 01/12/2006 23:19:21 0497 NEROLAC I was using =INDEX(F2:F10,MATCH(LEFT(B2,4),LEFT(G2:G10,4),FALS E),1) but it returns #N/A. can any one help with a formulae. thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae required
Did you array enetr it?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "shaji" wrote in message ... Hi, I have range of data from which i want to copy data of a column to another range. There is a column in both ranges in which first 4 digits are same. A B C Date Title TC Time 01/12/2006 0489NEROLAC PAIN #N/A 01/12/2006 0490NEROLAC PAIN 01/12/2006 0491NEROLAC PAIN 01/12/2006 0492NEROLAC PAIN 01/12/2006 0493NEROLAC PAIN 01/12/2006 0494NEROLAC PAIN 01/12/2006 0495NEROLAC PAIN 01/12/2006 0496NEROLAC PAIN 01/12/2006 0497NEROLAC PAIN E F G Date TC Time Title 01/12/2006 22:59:01 0489Grasim Ind-P 01/12/2006 22:59:16 0490PADMINI-Elec 01/12/2006 22:59:26 0491SWASTIK INVE 01/12/2006 22:59:36 0492Sharman Shaw 01/12/2006 22:59:46 0493Shree Cement 01/12/2006 22:59:51 0494CTC MALL-OPT 01/12/2006 23:19:01 0495Swagat Bania 01/12/2006 23:19:11 0496EVEREST MASA 01/12/2006 23:19:21 0497 NEROLAC I was using =INDEX(F2:F10,MATCH(LEFT(B2,4),LEFT(G2:G10,4),FALS E),1) but it returns #N/A. can any one help with a formulae. thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae required
No
"Bob Phillips" wrote: Did you array enetr it? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "shaji" wrote in message ... Hi, I have range of data from which i want to copy data of a column to another range. There is a column in both ranges in which first 4 digits are same. A B C Date Title TC Time 01/12/2006 0489NEROLAC PAIN #N/A 01/12/2006 0490NEROLAC PAIN 01/12/2006 0491NEROLAC PAIN 01/12/2006 0492NEROLAC PAIN 01/12/2006 0493NEROLAC PAIN 01/12/2006 0494NEROLAC PAIN 01/12/2006 0495NEROLAC PAIN 01/12/2006 0496NEROLAC PAIN 01/12/2006 0497NEROLAC PAIN E F G Date TC Time Title 01/12/2006 22:59:01 0489Grasim Ind-P 01/12/2006 22:59:16 0490PADMINI-Elec 01/12/2006 22:59:26 0491SWASTIK INVE 01/12/2006 22:59:36 0492Sharman Shaw 01/12/2006 22:59:46 0493Shree Cement 01/12/2006 22:59:51 0494CTC MALL-OPT 01/12/2006 23:19:01 0495Swagat Bania 01/12/2006 23:19:11 0496EVEREST MASA 01/12/2006 23:19:21 0497 NEROLAC I was using =INDEX(F2:F10,MATCH(LEFT(B2,4),LEFT(G2:G10,4),FALS E),1) but it returns #N/A. can any one help with a formulae. thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae required
No
Shaji "Bob Phillips" wrote: Did you array enetr it? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "shaji" wrote in message ... Hi, I have range of data from which i want to copy data of a column to another range. There is a column in both ranges in which first 4 digits are same. A B C Date Title TC Time 01/12/2006 0489NEROLAC PAIN #N/A 01/12/2006 0490NEROLAC PAIN 01/12/2006 0491NEROLAC PAIN 01/12/2006 0492NEROLAC PAIN 01/12/2006 0493NEROLAC PAIN 01/12/2006 0494NEROLAC PAIN 01/12/2006 0495NEROLAC PAIN 01/12/2006 0496NEROLAC PAIN 01/12/2006 0497NEROLAC PAIN E F G Date TC Time Title 01/12/2006 22:59:01 0489Grasim Ind-P 01/12/2006 22:59:16 0490PADMINI-Elec 01/12/2006 22:59:26 0491SWASTIK INVE 01/12/2006 22:59:36 0492Sharman Shaw 01/12/2006 22:59:46 0493Shree Cement 01/12/2006 22:59:51 0494CTC MALL-OPT 01/12/2006 23:19:01 0495Swagat Bania 01/12/2006 23:19:11 0496EVEREST MASA 01/12/2006 23:19:21 0497 NEROLAC I was using =INDEX(F2:F10,MATCH(LEFT(B2,4),LEFT(G2:G10,4),FALS E),1) but it returns #N/A. can any one help with a formulae. thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae required
You should. Edit the formula, F2, and then just hit Ctrl-Shift-Enter, rather
than just Enter. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "shaji" wrote in message ... No Shaji "Bob Phillips" wrote: Did you array enetr it? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "shaji" wrote in message ... Hi, I have range of data from which i want to copy data of a column to another range. There is a column in both ranges in which first 4 digits are same. A B C Date Title TC Time 01/12/2006 0489NEROLAC PAIN #N/A 01/12/2006 0490NEROLAC PAIN 01/12/2006 0491NEROLAC PAIN 01/12/2006 0492NEROLAC PAIN 01/12/2006 0493NEROLAC PAIN 01/12/2006 0494NEROLAC PAIN 01/12/2006 0495NEROLAC PAIN 01/12/2006 0496NEROLAC PAIN 01/12/2006 0497NEROLAC PAIN E F G Date TC Time Title 01/12/2006 22:59:01 0489Grasim Ind-P 01/12/2006 22:59:16 0490PADMINI-Elec 01/12/2006 22:59:26 0491SWASTIK INVE 01/12/2006 22:59:36 0492Sharman Shaw 01/12/2006 22:59:46 0493Shree Cement 01/12/2006 22:59:51 0494CTC MALL-OPT 01/12/2006 23:19:01 0495Swagat Bania 01/12/2006 23:19:11 0496EVEREST MASA 01/12/2006 23:19:21 0497 NEROLAC I was using =INDEX(F2:F10,MATCH(LEFT(B2,4),LEFT(G2:G10,4),FALS E),1) but it returns #N/A. can any one help with a formulae. thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recalculation of formulae disabled | Excel Discussion (Misc queries) | |||
| Using the results of formulae between different spreadsheets. | Excel Worksheet Functions | |||
| Change to formulae | Excel Worksheet Functions | |||
| Dynamic formulae - similar to lotus 123 for excel | Excel Discussion (Misc queries) | |||
| XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) | |||
Linear Mode
