Our first sheet
So you have a list of names in one column of a workbook - and you want to work out if they are attending a special event that is coming up.
Column A - has the list of names we are looking at (This is our Master List)
Column B - needs to be filled out with either a "Yes" or a "No" using our look-up from another list.
The information we want is actually on another Excel sheet - lets take a look at what this 'Other' sheet looks like...
Abe Dahbache has been working with EXCEL for over 15 years. He is a Microsoft Office User Specialist and has been developing solutions in Excel for some of the worlds largest companies.