|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 11:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com