| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF & VLOOKUP
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF & VLOOKUP
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF & VLOOKUP
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF & VLOOKUP
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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF & VLOOKUP
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
