Formulae required

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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),FALSE),1) but it
returns #N/A. can any one help with a formulae.

thanks in advance
 
Did you array enetr it?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
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)
 
Back
Top