Vlookup same ws & if MATCHED get a column

[hsandeep]

I am trying to get a cloumn value by doing vlookup on another sheet.
Ex:
Sheet1
Column A1:A9999
Sheet2
Column C1:C100
Column D1:D100=Values
In column E1:E100=Column D if Column C (of Sheet2) MATCHES with Column A (of Sheet1).
How to accomplish?

 

[hsandeep]

Someone pls help, I need it pls.

 

[Vidar]

Try this in E1:
=IF(ISNUMBER(MATCH(C1,Sheet1!$A$1:$A$9999,0)),D1,"")
and copy down.

Vidar