number cruncher
New Member
- Joined
- Aug 23, 2007
- Messages
- 2
I'm sure this is a simple thing but m excel skills are somewhat limited. Hoping someone can help.
I have 2 columns of data in sheet 1 under columns 'a' (titled 'Females') and 'b' (titled 'Male').
I have the same list of data but all in column 'a' of sheet 2 (listed in a different order than sheet 1).
In sheet 2, column b, if I want to insert which column (Males or females in sheet 1) that cell matches then what formula should I be using? NB, the cell value can appear in both columns a & b of sheet 1.
Thanks!!
I have 2 columns of data in sheet 1 under columns 'a' (titled 'Females') and 'b' (titled 'Male').
I have the same list of data but all in column 'a' of sheet 2 (listed in a different order than sheet 1).
In sheet 2, column b, if I want to insert which column (Males or females in sheet 1) that cell matches then what formula should I be using? NB, the cell value can appear in both columns a & b of sheet 1.
Thanks!!