Copy Cell Data From One Sheet To Another

[Pappy]

I'm not sure that what I want to do will work, but here goes.

I have one workbook containing two sheets. On sheet one, I have a cell,
let's say C2. In the next column, D2 and E3, I have empty cells.

In worksheet two, I have three columns with data in them.

What I need to do is set up something so that when I enter data in cell C2
of worksheet one and hit enter, a program or formula copies that data, goes
to worksheet two, searchs for the copied data, and when found, copies the
data from the found cell and the next two cells (find data in G1, copy data
from G1:I1) from worksheet two to cells D2:F2 in worksheet two.

Is this possible?

Any input would be appreciated.

[Tom Ogilvy]

IN D2
=IF(C2="","",Vlookup(D2,Sheet2!$G$1:$I$200,2,False))
in E2
=IF(C2="","",Vlookup(D2,Sheet2!$G$1:$I$200,3,False))

--
Regards,
Tom Ogilvy


"Pappy" <gporter5(nospam)@cox.net> wrote in message
news:[email protected]...
> I'm not sure that what I want to do will work, but here goes.
>
> I have one workbook containing two sheets. On sheet one, I have a cell,
> let's say C2. In the next column, D2 and E3, I have empty cells.
>
> In worksheet two, I have three columns with data in them.
>
> What I need to do is set up something so that when I enter data in cell C2
> of worksheet one and hit enter, a program or formula copies that data,
goes
> to worksheet two, searchs for the copied data, and when found, copies the
> data from the found cell and the next two cells (find data in G1, copy
data
> from G1:I1) from worksheet two to cells D2:F2 in worksheet two.
>
> Is this possible?
>
> Any input would be appreciated.

[Pappy]

Sir,

I had to play with this a little, but it all worked just fine after some
tinkering. Thanks a bunch for your help.

"Tom Ogilvy" <[email protected]> wrote in news:ODVkGmiNGHA.524
@TK2MSFTNGP09.phx.gbl:

> IN D2
> =IF(C2="","",Vlookup(D2,Sheet2!$G$1:$I$200,2,False))
> in E2
> =IF(C2="","",Vlookup(D2,Sheet2!$G$1:$I$200,3,False))
>