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

		Microsoft Office Forums > Microsoft Excel > Excel
Excel VLOOKUP - Return cells that are not blank from range of specified cells

FAQ

Thread Tools

Display Modes

05-09-2022, 11:59 AM

spillerbd

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

Office 2013

Competent Performer

Join Date: Jan 2016

Posts: 130

Quote:

Originally Posted by ArviLaanemets

The first formula has 7 nested IF's, what is a max number of nesting allowed!

Nested ifs are limited to 7 in the 32-bit version. Using the 64-bit version allows 64 levels of nesting.
64-bit is the preference for Excel and has recently become accepted. I have been 64-bit since, oh I forget when, 2010 I think.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:21 AM.