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