Excel VLOOKUP - Return cells that are not blank from range of specified cells

ArviLaanemets · #4 04-14-2022, 02:02 AM

Quote:

Originally Posted by Pecoflyer

As a matter of fact modern versions of XL ( starting at 2007 I think) will accept 64 levels of nested IF

After this was pointed out, I did find this information from MS Help (had to go to another page using a link, and reading through text there).

In past, there was the limit for number of nested IF's declared at end of MS Help for IF function. Not anymore! (Btw, I searched for this limit earlier, and couldn't find it then.)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
have a formula that combines two cells return a zero instead of a blank cell	Kubi	Excel	3	08-07-2017 11:52 PM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Vlookup fill down blank cells in column	mbesspiata	Excel Programming	8	09-26-2016 04:44 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM