Copy a value from one sheet if two cells match
 

Good Day, I am new to macros and have a bit of knowledge on excel. I woul
like to copy a Value from a cell if two fileds on different sheets math.

Copy a value from one sheet if two cells match
 

you dont ned a macro.You could have an if statement
=if(sheet1!A1=sheet2!a1,c5,"")
this says.if cell a1 on sheet1 equals cell a1 on sheet2 then show me the
value from cell c5(on whatever sheet you want to be on) otherwise be blank.
--
paul

remove nospam for email addy!



"Fuzzbucket" wrote:

Good Day, I am new to macros and have a bit of knowledge on excel. I woul
like to copy a Value from a cell if two fileds on different sheets math.

Copy a value from one sheet if two cells match
 

Thanks paul, I think i miss-explained myself if there is such a word. The
data on sheet two won't alaways be the same cell. So i need to look at a
column, then where a match is found return c5

"paul" wrote:

you dont ned a macro.You could have an if statement
=if(sheet1!A1=sheet2!a1,c5,"")
this says.if cell a1 on sheet1 equals cell a1 on sheet2 then show me the
value from cell c5(on whatever sheet you want to be on) otherwise be blank.
--
paul

remove nospam for email addy!



"Fuzzbucket" wrote:

Good Day, I am new to macros and have a bit of knowledge on excel. I woul
like to copy a Value from a cell if two fileds on different sheets math.

Copy a value from one sheet if two cells match
 

I need to do something like this as well, have you ever figured out how?

"Fuzzbucket" wrote:

Thanks paul, I think i miss-explained myself if there is such a word. The
data on sheet two won't alaways be the same cell. So i need to look at a
column, then where a match is found return c5

"paul" wrote:

you dont ned a macro.You could have an if statement
=if(sheet1!A1=sheet2!a1,c5,"")
this says.if cell a1 on sheet1 equals cell a1 on sheet2 then show me the
value from cell c5(on whatever sheet you want to be on) otherwise be blank.
--
paul

remove nospam for email addy!



"Fuzzbucket" wrote:

Good Day, I am new to macros and have a bit of knowledge on excel. I woul
like to copy a Value from a cell if two fileds on different sheets math.