Excel VLOOKUP

[JonesL]

I have a spreadsheet where I have an IF function in one of the columns. The type of IF function is dependent upon whether the entrants are Male or Female, as they have different sports results. Can I use a VLOOKUP function to enter the correct IF function into the specified cell when either 'Male' or 'Female' is typed into another cell? If so, my IF functions have specified cells in them (obviously for IF it contains a certain number, display this text) so what can I put instead of specific cell numbers that will get the correct ones each time? I hope this makes sense!

[pcstru]

I'm struggling to see what you are trying to do. You can't use VLookup to overwrite itself with another function (which is what it sounds like you are trying to do). You can use IINDIRECT function to specify the name of a cell to referr to, or you can generally use VLOOKUP to do state lookups (anything that reduces to a truth table - which is many if not most things).

 

Perhaps you could post a workbook with an example of what you are trying to do.

[localzuk]

Can you not use nested IF functions?

[dapaulio]

Is this something you are looking for?

 

=if(="male",vlookup(,

,,false),vlookup(,,) )

 

As there are only two outcomes for gender and if statement would be sufficient otherwise.

[LosOjos]

Is this something you are looking for?

 

=if(="male",vlookup(,

,,false),vlookup(,,) )

 

As there are only two outcomes for gender and if statement would be sufficient otherwise.

 

Or even simpler IMO:

 

=vlookup([i][/i],[i][/i],if([i][/i]="male",[i][/i], [i][/i]), FALSE)

[dapaulio]

Or even simpler IMO:

 

=vlookup([i][/i],[i][/i],if([i][/i]="male",[i][/i], [i][/i]), FALSE)

 

has the same outcome however I agree is simpler