Excel Excel, Office 2007, IF/THEN lookup between tabs

Joined
Jan 22, 2009
Messages
1
Reaction score
0
I have two tabs in my workbook, a master tab (sheet 1) and a deployment tab (sheet 2). The master tab lists all stores with all of their related data. The deployment tab lists only the stores that have had something done to them. Both tabs have the store number listed in column A.
In column B in the master tab, I want it to look at the deployment tab and if there is a match, put a Y and if not a N (or yes/no... whatever). Please help! I can not find the formula.
Thank you,
Charlotte
 
Back
Top