if function
 

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?

if function
 

I think you want to do a vlookup. On sheet 2, assuming there are headings in
the first row and data starts on the second row. Put this formula in cell C2
=vlookup(A2,Sheet1!$A$2:$D$6,3) and this in cell D2
=vlookup(A2,Sheet1!$A$2:$D$6,3) where $A$2:$D$6 = the range you are
querying.

"bakhour" wrote:

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?