Copy from one sheet to another but where values met

[Abhinay Gautam]

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

[JBeaucaire]

On sheet2 in B2, put this initial formula, then copy down and across as needed:

=IF(ISNUMBER(MATCH(A2, Sheet1!$A:$A, 0)), INDEX(Sheet1!B:B, MATCH(A2, Sheet1!$A:$A, 0)), "")