Sorting and extracting data...

Solved/Closed
Saud - Oct 31, 2011 at 03:18 AM
 Saud - Nov 16, 2011 at 01:45 AM
Hello,

I need to extract the data from from the cells of Column "B" and placed it into cells of Columns "E" by comparing Column"A" and Column"D".

 


Sample file attached herewith:

 


https://skydrive.live.com/embedicon.aspx/.Public/test.xls?cid=261a55c976ebb74a&sc=documents

Thanks

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Nov 1, 2011 at 10:56 AM
Hi Saud,

What are you looking for in the comparison?
What is the condition which determines to move data from B to E?
By extract data do you mean cut/paste or copy/paste?

Best regards,
Trowa
0
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
0
[A]--------------[B]-------------------------------------------[C]---------[D]------------[E]

[032670]-----[AL-MADINA MEDICAL STORE]------[ ]------[1032665]------[ ]
[034653]-----[ASIF MEDICAL STORE]---------------[ ]------[1032670]------[ ]
[032665]-----[BHITTAI MEDICAL STORE-----------[ ]------[1034653]------[ ]
0
i'm using this( =VLOOKUP(RIGHT(D1,6),A1:B930,2) ) formula in cells of column E
0
but its not working
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Nov 3, 2011 at 11:23 AM
Hi Saud,

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

Best regards,
Trowa
0