matching entries from one spreadsheet to data base

**Alan Gardner** · 03-18-2014, 09:18 AM

Hello
I run a bowling leagues which as 7 divisions and 10 teams per division, some of the clubs have up to 4 teams entered. I keep a spreadsheet for each division which keeps records of each teams performances as well as individual. All the clubs have to register their players for which I keep a data base for each club, the clubs having 4 teams register quite a number of players. My problem is I have to manually check the data base against players being entered on score cards and then on to the spreadsheet. Down columns B & C on the spreadsheet I have the Forename & Surname, when I enter a name in the cells I would like a formula to check against the clubs data base and return the name or false
Players Reg.xls 2014 stats - Copy.xls

**newdoverman** · 03-18-2014, 09:48 AM

This might serve your purposes. I combined both books because there really isn't a reason that I could see to have two books. I then inserted a helper column in both worksheets and a column to indicate if the names were in the database list or not.