Copy row depending on column value
 

Hi. I have an excel template that opens a workbook and takes values from it
using the INDIRECT function in cells. What I need to do now is look at Sheet
4 in the workbook and copy rows only if column B is equal to "CAT" or "DOG".
Is this possible?

Cathy

Copy row depending on column value
 

Combine Vlookup and the If statement. If it is the sum of values use Sumif

Copy row depending on column value
 

combine vlookup and if function. Use sumif it is values you need to be added

Copy row depending on column value
 

Thanks for the reply. Can you explain....

Cathy

"Roelof van Wyk" wrote:

Combine Vlookup and the If statement. If it is the sum of values use Sumif

Copy row depending on column value
 

I have never heard tell of the vlookup function

"Roelof van Wyk" wrote:

combine vlookup and if function. Use sumif it is values you need to be added

Copy row depending on column value
 

Will take some time, use the help files.

Vlookup - Searches for a value in the leftmost column of a table, and then
returns a value in the same row from a column you specify in the table. In
combining if before the vlookup you could get the answer you want i.e.
=if(A3="cat",Vlookup(a1,Sheet!'sheet1'A1:c20,3,Fal se),...