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