Excel Questions

[mok123]

Hi,

Taking this data into consideration :

Cell A Cell B Cell C Cell D
FL1000 7FB15 FL1000 36,641.06
FL1001 02-7FD40 FL1001 51,547.95
FL1003 62-7FD30 FL1002 37,758.91
FL1004 62-7FD30 FL1003 37,095.84
FL1005 62-7FD25 FL1004 33,618.47

I need to compare, match common data in Cell A & D which will result as follows :

Cell A Cell B Cell C
FL1000 7FB15 36,641.06
FL1001 02-7FD40 51,547.95
FL1002 37,758.91
FL1003 62-7FD30 37,095.84
FL1004 62-7FD30 33,618.47
FL1005 62-7FD25

How can I achieve the above in Excel 97 by means of automation (macro, VBA etc,etc).

Suggestions are greatly appreciated.

Thanks

Mok

 

[mok123]

Hi,

I managed to find a solution by using VLOOKUP. But if anyone has better ideas, it is most welcome.

regards,

Mok