C
Carolina
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,'Property
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))
Thanks a million!
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,'Property
List'!L19:M31,2,0),if(B8="Large","",vlookup('Team Bonus'!A14,'Property
List'!L35:M47,2,0))))
Thanks a million!