thanks for repply..i've try that but VLOOKUP only return a single
value.moreover,the 2 columns i need is not side by side.

--
Regards,
Linda


"Teethless mama" wrote:

Take a look a VLOOKUP function in Help menu


"linda" wrote:

Hi!
i am trying to copy data of certains rows from 2 columns that match the
criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
DATE,but i want to copy column CUST & MOD to another worksheet.can it be done?
i've tried to use advanced filter,but it seems like copy DATE column
only,cannot copy CUST & MOD.
is there any other suggestion?
thanks in advance=)

--
Regards,
Linda