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; (306187.50, « »)

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

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