View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
shaji shaji is offline
external usenet poster
 
Posts: 28
Default 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