I am about to create a database in Excel (I'd rather not use Access) and I am currently testing what I can do before I start typing in 500 records. I want to use the VLOOKUP function to return if a certain person is attending a certain thing, say the Wine and Cheese. I have tried to create a VLOOKUP function and it only works for certian people in the list Can VLOOKUP return text and if so can someone please help straighten me out. Thanks
*Sample is attached*
Bookmarks