Perhaps something like:

=IF(A2="MALE",VLOOKUP(A3,$W$1:$X$100,2,FALSE),IF(A 2="FEMALE",VLOOKUP(A3,$Y$1:$Z$100,2,FALSE),""))

Where A2 would contain Male or Female
A3 would contain the parameter to lookup
W1:X100 would contain the Male Table
Y1:Z100 would contain the Female Table.

Of course, you would adjust all these references as necessary and
change Male/Female to M/F or whatever way you indicate gender.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489900