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
|