OK Guys, I have multiple sheets in a book, where the master sheet contains

account Number | account Name | TYPE | Outlet Number
1731 Grand Phr Chain 6

I want to move TYPE and OUTLET NUMBER to all the other sheets where the
account number might exist

I tried the If function (=if(A2sheet1=A2sheet2;C2;" ")
but i would get an incomplete result, the formula will stop if the contuem is
not maching

What should i try to make it ignore the contuem and search and fill by
account number?