Forum Discussion
MS Excel IF / MATCH
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...
Disregard. The following worked:
=IFERROR(INDEX($H1:$H442, MATCH(A1, $G1:$G442, 0)), " ") after manually typing it in and pressing Ctrl+Shift+Enter to enter an array formula.
=IFERROR(INDEX($H1:$H442, MATCH(A1, $G1:$G442, 0)), " ") after manually typing it in and pressing Ctrl+Shift+Enter to enter an array formula.