### Tags: argument, excel, formula, formulas, inside, microsoft, msdn, nesting, references, software, vlookup

# Nesting Formulas

On Microsoft » Microsoft Excel

3,415 words with 2 Comments; publish: Wed, 04 Jun 2008 12:30:00 GMT; (306109.38, « »)

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...

*http://excel.todaysummary.com/q_microsoft-excel_330450.html*

All Comments

Leave a comment...

- 2 Comments
- 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

Regards,

Peo Sjoblom

"PLCProgrammer" <PLCProgrammer.excel.todaysummary.com.discussions.microsoft.com> wrote in message

news:7570E177-C807-4830-B0E7-B0139A8742FA.excel.todaysummary.com.microsoft.com...

> 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...

#1; Wed, 04 Jun 2008 12:31:00 GMT

- Are you using the equal sign within the if fucntion or was it just an
- 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(A1>20000,VLOOKUP(A1, etc, etc...,FALSE),VLOOKUP(A1, etc, etc...,FALSE))

>

> should work

>

> --

> Regards,

> Peo Sjoblom

>

> "PLCProgrammer" <PLCProgrammer.excel.todaysummary.com.discussions.microsoft.com> wrote in message

> news:7570E177-C807-4830-B0E7-B0139A8742FA.excel.todaysummary.com.microsoft.com...

> > 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...

>

>

#2; Wed, 04 Jun 2008 12:32:00 GMT

- Peo,