Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: LOOKUP and VLOOKUP

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Kent, the Garden of England, that no one has bothered to weed.
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a limit to the number of LOOKUP and VLOOKUP functions that can be used in a single formula similar to the maximum of 7 nested IF functions limit ?

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have a look in Excel Help, type in the search field "limitations".

    This tells you that you are limited to 7 nested functions. I guess this means for any type of function, be it "IF" "LOOKUP" or whatever.

    HTH

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •