Nesting Formulas

[Guest]

Hi,
I'm trying to use the VLOOKUP formula as the argument inside an IF formula.
I'm doing this because my VLOOKUP references a different file that has
30,000 rows in it, and that seems to be making my VLOOKUP fail due to lack of
system resources.
Anyway, here is how I am trying my IF statement:

=IF(A1>20000, =VLOOKUP(A1, etc, etc...,FALSE),VLOOKUP(A1, etc, etc...,FALSE))

My IF statement is using two different VLOOKUP functions as arguments, so
that I can look up data in two unique source files.

But, my IF statement returns an error if I do this. Any thoughts? I tried
adding parenthesese, also double-quotes, but I can't get it to work.
Thanks....

 

[Peo Sjoblom]

Are you using the equal sign within the if fucntion or was it just an
accident when you copied the formula?

=IF(A1>20000,VLOOKUP(A1, etc, etc...,FALSE),VLOOKUP(A1, etc, etc...,FALSE))


should work

 

[Guest]

Peo,
Thank you. Yes, I did need to remove the = sign in both arguments. That
worked.
Thanks!!!!!!!!