IF M/F then Vlookup table X/Y

[claz2201]

Hi guys,

So i have a big table which has males and females on (indicated in column C) and their 100m run times (column H). In column 'I' I am wanting another score based on a vlookup table elsewhere. I am wanting a formula (that works) something along the line of...

IF C2 = M then Vlookup table 1, if F then vlookup table 2.


Hope this makes sense!

Claire

 

[Eric W]

Something like:

=VLOOKUP(H3,IF(C3="m",$M$1:$N$7,$P$1:$Q$7),2)

where M1:N7 and P1:Q7 are your 2 tables, or you could use named ranges:

=VLOOKUP(H3,IF(C3="m",MaleTable,FemaleTable),2)