Automatically filling information in Excel Database

Hello,

I have to do an analysis on an online membership database within excel, but for some reason, some of the cells under the Gender column remain unfilled. Instead of manually filling each cell in, I would like to be able to do it automatically, where a code checks male and female naming dictionary and, if the first name of the member matches a male entry in the dictionary, to enter “Male” or “Female” in the corresponding cell (and if the code can’t find the name to leave it blank – I would elect to do this instead of using, say, the male dictionary and making all names that can’t be found female because some of the names are foreign and probably can’t be found in the dictionary) I do not have any coding experience, so if I could get guidance of some kind (a viable programming language for this task, general outline of the code, how to search multiple web pages, etc) before starting this project, I would highly appreciate it!