HELP ON THE VLOOK UP FUNCTION FOR MULTIPLE VALUES.

J

John

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 [email protected].

Thanks in advance!

John
 
D

Dave Peterson

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,someotherrange)),match(...),0)

But I think you'll want to give more details.
 
J

John

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
 
D

Dave Peterson

Please keep the discussion in the newsgroup.

There'll be lots more people who will read your post.
 
Top