Limit to nested Vlookups
 

Is there a limit to the number of nested Vlookups you can have?


--
karambos
------------------------------------------------------------------------
karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262
View this thread: http://www.excelforum.com/showthread...hreadid=399401

There's a limit of 7 nested levels (not just for =vlookup()).

karambos wrote:

Is there a limit to the number of nested Vlookups you can have?

--
karambos
------------------------------------------------------------------------
karambos's Profile: http://www.excelforum.com/member.php...o&userid=16262
View this thread: http://www.excelforum.com/showthread...hreadid=399401

--

Dave Peterson

karambos wrote in
:

Is there a limit to the number of nested Vlookups you can have?


Nesting of functions is limited to 7.

http://office.microsoft.com/en-us/as...992911033.aspx


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)