software

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;quot; quot;)
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?

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.

quot;bakhourquot; wrote:

gt; OK Guys, I have multiple sheets in a book, where the master sheet contains
gt;
gt; account Number | account Name | TYPE | Outlet Number
gt; 1731 Grand Phr Chain 6
gt;
gt; I want to move TYPE and OUTLET NUMBER to all the other sheets where the
gt; account number might exist
gt;
gt; I tried the If function (=if(A2sheet1=A2sheet2;C2;quot; quot;)
gt; but i would get an incomplete result, the formula will stop if the contuem is
gt; not maching
gt;
gt; What should i try to make it ignore the contuem and search and fill by
gt; account number?
gt;