Hi Gurus,

I want to copy value from one sheet to another but based on a condition if it meets.

E.g I have two sheets:
Sheet 1: Column A(Order no), Column B(Price), Column C(Order date)

A2001 $10 01.07.2012
A2002 $30 04.07.2012
A2003 $50 30.07.2012


Sheet 2: Column A(Order no), Column B(Price), Column C(Order date)

A2001

In sheet 2, I have only Order no and I want to copy Price and Order date from sheet 1 where Order no. is matched.

Please suggest how this can be achieved.

Thnx
Aby