Given an MS Excel spreadsheet with a list of names in column A (A1:A5519), another list of names in column G (G1:G442), and known gender in column H (H1:H442), how can I compare each name in column A to all names in column G and assign column C (C1:C5519) with a gender value from column H when a match is found between columns A and G?
I've tried ChatGPT, and it's given a few different possibilities, all of which looked promising, but none of which worked. Any assistance would be greatly appreciated.
