Find and Match in one worksheet and get data (Very Urgent)
 

I have two worksheet named sheet1 ans sheet2
My sourcedata in sheet one in two columns is as follows
V1 V2
30 100
31 100
- 206
- 323
30 202
31 203

If these two value matches in both sheets i.e sheet1 and sheet2 then I have
to copy the data from sheet2 to sheet1 in a row corresponding to that value

Any help will be greatly appreciated

Thanx in advance

Lolly
--
Kittie