Matching information.

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

I need help on how to do this:

Column A Column B Column G Column
F
Adam, Marks Blank (list of names)
Genders
bob, s note some same as A some not
..
..
..
List of names

I want to Check to see if name in G matches A (even if out of order in
G) and paste corresponding gender in column B. What functions would
I use to do this.

Thanks,

Bonnie
 
If the gender is in the column to the right of column G, you can use a
VLOOKUP. For example, in cell B1: =VLOOKUP(A1,$G$1:$H$3,2,FALSE)

If gender is to the left, you can use INDEX/MATCH. In cell B1:
=INDEX($F$1:$F$3,MATCH(A1,$G$1:$G$3,0))
 
Back
Top