I have 2 excel spreadsheets. One has all of our employee information and the
other one just has employee id. The worksheet with employee id needs to be
updated with gender. How can I do this without looking up each 1
individually? I am looking for a way to automate this process. Thank you.