Nesting Formulas
 

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(A120000, =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....

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

=IF(A120000,VLOOKUP(A1, etc, etc...,FALSE),VLOOKUP(A1, etc, etc...,FALSE))


should work


--

Regards,

Peo Sjoblom



"PLCProgrammer" wrote in message
...
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(A120000, =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,
Thank you. Yes, I did need to remove the = sign in both arguments. That
worked.
Thanks!!!!!!!!

"Peo Sjoblom" wrote:

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

=IF(A120000,VLOOKUP(A1, etc, etc...,FALSE),VLOOKUP(A1, etc, etc...,FALSE))


should work


--

Regards,

Peo Sjoblom



"PLCProgrammer" wrote in message
...
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(A120000, =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....