Sorting and extracting data...

Hi Trowa,

You can find the excel file here:

https://skydrive.live.com/?cid=261a55c976ebb74a&sc=documents&id=261A55C976EBB74A%21260

First download it by clicking on right bar where download option is visible under file thumbnail.

In that file i have 5 columns
1st column is of customer code
2nd one is of customer name
3rd one is empty
on 4th column there are same customers codes which are in 1st column with prefix value "1"
now on 5th column i need the list of customers name by comparing codes of 1st and 3rd column

for example

[ A ]------[ B ]-------------------------------------[ C ]------[ D ]------[ E ]

[032670]-----[AL-MADINA MEDICAL STORE]------[ ]------[1032665]------[ ]
[034653]-----[ASIF MEDICAL STORE]---------------[ ]------[1032670]------[ ]
[032665]-----[BHITTAI MEDICAL STORE-----------[ ]------[1034653]------[ ]

now by comparing A1 with D2, B1 will be on E2


Regards,

Saud Khan

[A]--------------[B]-------------------------------------------[C]---------[D]------------[E]

[032670]-----[AL-MADINA MEDICAL STORE]------[ ]------[1032665]------[ ]
[034653]-----[ASIF MEDICAL STORE]---------------[ ]------[1032670]------[ ]
[032665]-----[BHITTAI MEDICAL STORE-----------[ ]------[1034653]------[ ]

i'm using this( =VLOOKUP(RIGHT(D1,6),A1:B930,2) ) formula in cells of column E

but its not working

Hi Saud,

When using VLOOKUP your matrix (column A:B) MUST be sorted in order to work properly.

Best regards,
Trowa