Copy a value from one sheet if two cells match

F

Fuzzbucket

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.
 
P

paul

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.
 
F

Fuzzbucket

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
 
Top