MrStressed
Board Regular
- Joined
- Mar 25, 2002
- Messages
- 65
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 ?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
LOOKUP and VLOOKUP
- Thread starter MrStressed
- Start date
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
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
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
Upvote
0
Similar threads
- Question
