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
 

You might want to try VLOOKUP
http://theofficeexperts.com/downloads.htm
this site has a good VLOOKUP example


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=535138