ExcelBanter - IF & VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF & VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/188367-if-vlookup.html)

Once again I refer to you for help!
I need a formula that will return certain valued based on the fact if they
are Small, Medium or Large. For example, if someone says the product is small
if should go to a table I have and look up the values for the column and
return them...if they say Large then it should take another set of numbers
I was thinking the following formula but Excel says I have too many
arguments for this formula....can you assist?

=(IF(B8="Small","",VLOOKUP(A14,'Property
List'!L3:M15,2,0),if(B8="Medium","",vlookup(A14,'P roperty
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))

Thanks a million!

I think you are trying to do something like this:

=(IF(B8="Small",VLOOKUP(A14,'Property List'!
L3:M15,2,0),IF(B8="Medium",VLOOKUP(A14,'Property List'!
L19:M31,2,0),IF(B8="Large",VLOOKUP(A14,'Property List'!
L35:M47,2,0),"")))

Hope this helps.

Pete

On May 21, 4:47*pm, Carolina
wrote:
Once again I refer to you for help!
I need a formula that will return certain valued based on the fact if they
are Small, Medium or Large. For example, if someone says the product is small
if should go to a table I have and look up the values for the column and
return them...if they say Large then it should take another set of numbers
I was thinking the following formula but Excel says I have too many
arguments for this formula....can you assist?

=(IF(B8="Small","",VLOOKUP(A14,'Property
List'!L3:M15,2,0),if(B8="Medium","",vlookup(A14,'P roperty
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))

Thanks a million!

Try

=IF(B8="Small",VLOOKUP(A14,'Property List'!L3:M15,2,0),IF(B8="Medium",VLOOKUP(A14,'Prop erty
List'!L19:M31,2,0),IF(B8="Large",VLOOKUP('Team Bonus'!A14,'Property List'!L35:M47,2,0),"Enter a size
in B8")))

HTH,
Bernie
MS Excel MVP

"Carolina" wrote in message
...
Once again I refer to you for help!
I need a formula that will return certain valued based on the fact if they
are Small, Medium or Large. For example, if someone says the product is small
if should go to a table I have and look up the values for the column and
return them...if they say Large then it should take another set of numbers
I was thinking the following formula but Excel says I have too many
arguments for this formula....can you assist?

=(IF(B8="Small","",VLOOKUP(A14,'Property
List'!L3:M15,2,0),if(B8="Medium","",vlookup(A14,'P roperty
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))

Thanks a million!

Thank you for taking the time...it worked like a charm!

"Pete_UK" wrote:

I think you are trying to do something like this:

=(IF(B8="Small",VLOOKUP(A14,'Property List'!
L3:M15,2,0),IF(B8="Medium",VLOOKUP(A14,'Property List'!
L19:M31,2,0),IF(B8="Large",VLOOKUP(A14,'Property List'!
L35:M47,2,0),"")))

Hope this helps.

Pete

On May 21, 4:47 pm, Carolina
wrote:
Once again I refer to you for help!
I need a formula that will return certain valued based on the fact if they
are Small, Medium or Large. For example, if someone says the product is small
if should go to a table I have and look up the values for the column and
return them...if they say Large then it should take another set of numbers
I was thinking the following formula but Excel says I have too many
arguments for this formula....can you assist?

=(IF(B8="Small","",VLOOKUP(A14,'Property
List'!L3:M15,2,0),if(B8="Medium","",vlookup(A14,'P roperty
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))

Thanks a million!

You're welcome - thanks for feeding back.

Pete

On May 21, 5:45*pm, Carolina
wrote:
Thank you for taking the time...it worked like a charm!

"Pete_UK" wrote:
I think you are trying to do something like this:

=(IF(B8="Small",VLOOKUP(A14,'Property List'!
L3:M15,2,0),IF(B8="Medium",VLOOKUP(A14,'Property List'!
L19:M31,2,0),IF(B8="Large",VLOOKUP(A14,'Property List'!
L35:M47,2,0),"")))

Hope this helps.

Pete

On May 21, 4:47 pm, Carolina
wrote:
Once again I refer to you for help!
I need a formula that will return certain valued based on the fact if they
are Small, Medium or Large. For example, if someone says the product is small
if should go to a table I have and look up the values for the column and
return them...if they say Large then it should take another set of numbers
I was thinking the following formula but Excel says I have too many
arguments for this formula....can you assist?

=(IF(B8="Small","",VLOOKUP(A14,'Property
List'!L3:M15,2,0),if(B8="Medium","",vlookup(A14,'P roperty
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))

Thanks a million!- Hide quoted text -

- Show quoted text -