B
bakhour
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?
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?