| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES.
This is the if then statement that I built for my project.
If(a3="2.5",Vlookup(d5,web_25,Match(R2,headers),0, false) 1. How many of this statement that I can build ? 2. In doing this, I have limited the vlookup of the value of "2.5" for cell a3 . I would like to be able to use cell a3 for multiple lookup values (may be link/equal to the value defined from another table/drop down menu). Currently, anytime I changed the value in cell a3 then I need to modify the value in the if then statement for cell a3. This is very inefficient. Any suggestions on how I could achieve this flexibility? My email address is . Thanks in advance! John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES.
I'm not sure what you're doing, but your =vlookup() has too many arguments (0 or
false--not both). But you can use if statements within the =vlookup(). And you can use =indirect() within that =vlookup(). And you may want to be careful with 2.5. If your data is really numeric (not text), you don't want to use the ""s. If you were changing the range to lookup, you could use something like: =vlookup(d5,indirect(if(a3=2.5,web_25,someotherran ge)),match(...),0) But I think you'll want to give more details. John wrote: This is the if then statement that I built for my project. If(a3="2.5",Vlookup(d5,web_25,Match(R2,headers),0, false) 1. How many of this statement that I can build ? 2. In doing this, I have limited the vlookup of the value of "2.5" for cell a3 . I would like to be able to use cell a3 for multiple lookup values (may be link/equal to the value defined from another table/drop down menu). Currently, anytime I changed the value in cell a3 then I need to modify the value in the if then statement for cell a3. This is very inefficient. Any suggestions on how I could achieve this flexibility? My email address is . Thanks in advance! John -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES.
For additional help with VLOOKUP combined with MATCH see
http://www.mvps.org/dmcritchie/excel/vlookup.htm#match Looking up data in tables, Chip Pearson http://www.cpearson.com/excel/lookups.htm Excel -- Worksheet Functions -- INDEX / MATCH, Debra Dalgleish http://www.contextures.com/xlFunctions03.html --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave Peterson" wrote in message ... I'm not sure what you're doing, but your =vlookup() has too many arguments (0 or false--not both). But you can use if statements within the =vlookup(). And you can use =indirect() within that =vlookup(). And you may want to be careful with 2.5. If your data is really numeric (not text), you don't want to use the ""s. If you were changing the range to lookup, you could use something like: =vlookup(d5,indirect(if(a3=2.5,web_25,someotherran ge)),match(...),0) But I think you'll want to give more details. John wrote: This is the if then statement that I built for my project. If(a3="2.5",Vlookup(d5,web_25,Match(R2,headers),0, false) 1. How many of this statement that I can build ? 2. In doing this, I have limited the vlookup of the value of "2.5" for cell a3 . I would like to be able to use cell a3 for multiple lookup values (may be link/equal to the value defined from another table/drop down menu). Currently, anytime I changed the value in cell a3 then I need to modify the value in the if then statement for cell a3. This is very inefficient. Any suggestions on how I could achieve this flexibility? My email address is . Thanks in advance! John -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES.
Hi Dave,
I tried to send you the file that I am currently working on with additional information. The email that I got from this discussion group is not valid. Is there an email address that I can send you the file to you? Thanks John "Dave Peterson" wrote: I'm not sure what you're doing, but your =vlookup() has too many arguments (0 or false--not both). But you can use if statements within the =vlookup(). And you can use =indirect() within that =vlookup(). And you may want to be careful with 2.5. If your data is really numeric (not text), you don't want to use the ""s. If you were changing the range to lookup, you could use something like: =vlookup(d5,indirect(if(a3=2.5,web_25,someotherran ge)),match(...),0) But I think you'll want to give more details. John wrote: This is the if then statement that I built for my project. If(a3="2.5",Vlookup(d5,web_25,Match(R2,headers),0, false) 1. How many of this statement that I can build ? 2. In doing this, I have limited the vlookup of the value of "2.5" for cell a3 . I would like to be able to use cell a3 for multiple lookup values (may be link/equal to the value defined from another table/drop down menu). Currently, anytime I changed the value in cell a3 then I need to modify the value in the if then statement for cell a3. This is very inefficient. Any suggestions on how I could achieve this flexibility? My email address is . Thanks in advance! John -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES.
Please keep the discussion in the newsgroup.
There'll be lots more people who will read your post. John wrote: Hi Dave, I tried to send you the file that I am currently working on with additional information. The email that I got from this discussion group is not valid. Is there an email address that I can send you the file to you? Thanks John "Dave Peterson" wrote: I'm not sure what you're doing, but your =vlookup() has too many arguments (0 or false--not both). But you can use if statements within the =vlookup(). And you can use =indirect() within that =vlookup(). And you may want to be careful with 2.5. If your data is really numeric (not text), you don't want to use the ""s. If you were changing the range to lookup, you could use something like: =vlookup(d5,indirect(if(a3=2.5,web_25,someotherran ge)),match(...),0) But I think you'll want to give more details. John wrote: This is the if then statement that I built for my project. If(a3="2.5",Vlookup(d5,web_25,Match(R2,headers),0, false) 1. How many of this statement that I can build ? 2. In doing this, I have limited the vlookup of the value of "2.5" for cell a3 . I would like to be able to use cell a3 for multiple lookup values (may be link/equal to the value defined from another table/drop down menu). Currently, anytime I changed the value in cell a3 then I need to modify the value in the if then statement for cell a3. This is very inefficient. Any suggestions on how I could achieve this flexibility? My email address is . Thanks in advance! John -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Lookup Function Referencing cells, not text values | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Linear Mode
