Hi

I have two worksheets.Sheet1 and sheet 2.If values of column1
sheet1 is prent in Column D of sheet2 then that values of sheet 2
should get copy bpasted into sheet3.Looking for help.

Thanks and Regards!

Gururaja

You can add a column to Sheet2 that will determine if the row should be
copied or not. For example, if your data in Sheet2 starts in row 3, then
pick a column to the right of the data in Sheet 2, and put this in that
column of row 3:

=IF(ISNA(VLOOKUP(D3,Sheet1!A$2:A$35,1,FALSE)),"No" ,"Yes")

If you start on a different row in Sheet2 than row 3, change the D3 to
reference the first cell in column D you want to look up in Sheet1. Change
the numbers for A$2 and A$35 to use the correct rows in Sheet1. You want the
$ to remain in the formula. Once this is correct, then drag this down for
all the rows in Sheet 2.

From here, depending on how you want the copy/paste done, you can Data |
Filter | Filter All on the data in Sheet2, filter on 'Yes' and manually copy
/ paste into Sheet 3. Alternatively, you can put formulas in Sheet3 to
reference Sheet 2 only if the corresponding column in Sheet2 has a 'Yes' in
it.

If you don't want to see the column in Sheet2, you can build the formulas in
sheet 3 to do the lookup, but if there is a lot of data, it can be slow.
--
Daryl S


"guru" wrote:

Hi

I have two worksheets.Sheet1 and sheet 2.If values of column1
sheet1 is prent in Column D of sheet2 then that values of sheet 2
should get copy bpasted into sheet3.Looking for help.

Thanks and Regards!

Gururaja