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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top