Matching information.

[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

 

[Debra Dalgleish]

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))